Case statement in dax

[Anonymous]

Hello All,

Below is my formula which is in tableau and need to do the same in Power Bi.

Here select call/Chat/Overall is a parameter in Tableau..

and region is my column from db table

For this I created a table inside power bi and created a slicer , but not sure how to create this formula.

Couls any one please help how to do this.

CASE [Region]

    WHEN "Overall" THEN

        case [select call/Chat/Overall]

        when "Phone" then sum(ASPhoneCalls)+sum(BSPhoneCalls)

        when "Chat" then  sum(ASChats)+sum(BSChats)

        when "Overall" then sum(ASPhoneCalls)+ sum(ASChats)+sum(BSPhoneCalls)+ sum(BSChats)

        end

    WHEN "AS" THEN

        case [select call/Chat/Overall]

        when "Phone" then sum(ASPhoneCalls)

        when "Chat" then sum(ASChats)

        when "Overall" then sum(ASPhoneCalls)+ sum(ASChats)

        end

    WHEN "BS" THEN

        case [select call/Chat/Overall]

        when "Phone" then sum(BSPhoneCalls)

        when "Chat" then sum(BSChats)

        when "Overall" then sum(BSPhoneCalls)+ sum(BSChats)

        end   

END

[Anonymous · Accepted solution]

Hi @Anonymous ,

Please have a try.

Create a column. Use if or switch.

Column=IF(CASE[Region]="Overall"&&CASE[select call/Chat/Overall]="Phone",sum(ASPhoneCalls)+sum(BSPhoneCalls),IF(CASE[Region]="Overall"&&CASE[select call/Chat/Overall]="Chat",sum(ASChats)+sum(BSChats),IF(CASE[Region]="Overall"&&CASE[select call/Chat/Overall]="Overall", sum(ASPhoneCalls)+ sum(ASChats)+sum(BSPhoneCalls)+ sum(BSChats),if(CASE[Region]="AS"&&CASE[select call/Chat/Overall]="Phone", sum(ASPhoneCalls),if(CASE[Region]="AS"&&CASE[select call/Chat/Overall]="Chat",sum(ASChats),if(CASE[Region]="AS"&&CASE[select call/Chat/Overall]="Overall",sum(ASPhoneCalls)+ sum(ASChats),IF(CASE[Region]="BS"&&CASE[select call/Chat/Overall]="Phone", sum(BSPhoneCalls),IF(CASE[Region]="BS"&&CASE[select call/Chat/Overall]="Chat",sum(BSChats),IF(CASE[Region]&&CASE[select call/Chat/Overall]="Overall",sum(BSPhoneCalls)+ sum(BSChats),BLANK()))))))))

COLUMN=SWITCH(TRUE(),SELECTEDVALUE('CASE'[Region])="Overall"
                             &&SELECTEDVALUE(case [select call/Chat/Overall])="Phone",
                                sum(ASPhoneCalls)+sum(BSPhoneCalls),
                      SELECTEDVALUE('CASE'[Region])="Overall"
                             &&SELECTEDVALUE(case [select call/Chat/Overall])="Chat",
                                 sum(ASChats)+sum(BSChats),
                       SELECTEDVALUE('CASE'[Region])="Overall"
                              &&SELECTEDVALUE(case [select call/Chat/Overall])="Overall",
                                 sum(ASPhoneCalls)+ sum(ASChats)+sum(BSPhoneCalls)+ sum(BSChats),
                     SELECTEDVALUE('CASE'[Region])="AS"
                             &&SELECTEDVALUE(case [select call/Chat/Overall])="Phone",
                                sum(ASPhoneCalls),
                     SELECTEDVALUE('CASE'[Region])="AS"
                              &&SELECTEDVALUE(case [select call/Chat/Overall])="Chat",
                                  sum(ASChats),
                      SELECTEDVALUE('CASE'[Region])="AS"
                              &&SELECTEDVALUE(case [select call/Chat/Overall])="Overall",
                                   sum(ASPhoneCalls)+ sum(ASChats)
                       SELECTEDVALUE('CASE'[Region])="BS"
                              &&SELECTEDVALUE(case [select call/Chat/Overall])="Phone",
                                   sum(BSPhoneCalls),
                       SELECTEDVALUE('CASE'[Region])="BS"
                              &&SELECTEDVALUE(case [select call/Chat/Overall])="Chat",
                                    sum(BSChats),
                        SELECTEDVALUE('CASE'[Region])="BS"
                               &&SELECTEDVALUE(case [select call/Chat/Overall])="Overall",
                                    sum(BSPhoneCalls)+ sum(BSChats),blank())

If I have misunderstood your meaning, please provide more details with your desired output and your pbix file without privacy information.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Tahreem24]

@Anonymous You can use SWITCH statement for this purpose. You can find the details on these blogs.

https://docs.microsoft.com/en-us/dax/switch-function-dax

https://dax.guide/switch/