How to create new Variable based on another multiple Variable using if, else statement ?

[gauravsinghtomar]

Hello experts,

I need to create a statement for new Variable based on another multiple Variable using if, else statement.

some Variable has a different value, I needed a statement on behalf of other columns.

Find an example below:-

Variable	Variable	Variable	Variable	Variable	Needed Statement (Result)
Column1	Column2	Column3	Column4	Column5	Permission.Check
1	Permission	John		Allow	Permission
1	Permission	John		Allow	Permission
1	Delete	John		Allow	Permission
2	Permission	John		Allow	Delete
2	Permission	John		Allow	Delete
2	Delete	John		Allow	Delete
2	Delete	John		Allow	Delete
3	Permission	John		Allow
3	Delete	John		Allow
4	Permission	John	XYZ	Allow
4	Delete	John		Deny

Power BI DAX Queries given below. I need syntax similar to these:-

Power BI DAX Queries:-

Permissions.Check =

VAR Permissions = CALCULATE(COUNTROWS(TableName),ALLEXCEPT(TableName,TableName[column1],tableName[column2]))

VAR Delete =
    CALCULATE(
        COUNTROWS(TableName),
            FILTER(
                ALLEXCEPT(TableName,TableName[column1],TableName[column2]),
                    TableName[column3]="John"&&
                    ISBLANK(TableName[column4])
                )
            )

RETURN
SWITCH(TRUE(),
    TableName[column5]<>"Allow",BLANK(),

    Permissions=2&&Delete=1,"Permission",

    Permissions=2&&Delete=2,"Delete",

   BLANK()

)