Tableau to power BI migration

[Anonymous]

Hi ,

I am trying to convert below Tableau calculation to Power BI DAX, but I am not getting the expected result with my calculations. May be I am not dealing properly with the null values

Please help me with the conversion of below code:

IF ifnull([detail calc],0)<=.85 then 'Low Performing'
ELSEIF (ifnull(([detail calc]),0)>.85 and ifnull(([detail calc]),0) <= 1) then 'On Target'
ELSEIF (ifnull(([detail calc]),0)>1 ) then 'Over Performing'
END

Where  "detail calc"-->

{FIXED [Region],[Country],[Year]:SUM([Net Rev Act]) } / {FIXED [Region],[Country],[Year]:sum([Net Rev Tgt]) }

*** "Net Rev Act" and "Net Rev Tgt"  contains null values as well and these are the direct columns. [Region], [Country], [Year] are also direct fields from table

[v-yanjiang-msft]

Hi @Anonymous ,

Is your problem solved?? If so, Would you mind accept the helpful replies as solutions? Then we are able to close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.

Best Regards,
Community Support Team _ kalyj

[Anonymous]

Hi @v-yanjiang-msft ,

Please allow me some more time. I have taken help from the solution provided by @amitchandak  and applied it but I am awaiting confirmation from my Senior Analyst.

I will definitely Accept it as a solution once I get a confirmation. 

Thanks in advance for understanding.

Regrads'

Rishabh 

[amitchandak · Accepted solution]

@Anonymous , Try like

Switch(True() ,
coalesce([detail calc],0) <=.85 , "Low Performing" ,
coalesce([detail calc],0) <= 1 ,"On Target",
coalesce([detail calc],0)>1 , "Over Performing"
)

for fixed

divide( calculate(SUM([Net Rev Act]) , allexcept(Table, [Region],[Country],[Year])), calculate(SUM([Net Rev Tgt]) , allexcept(Table, [Region],[Country],[Year])) )

refer

Tableau Vs Power BI- Chapter 6- LOD- FIXED (Level of Details): https://youtu.be/hU-cVOwDCvY

Tableau Vs Power BI: https://www.youtube.com/watch?v=tAmg00Wf_cw&list=PLPaNVDMhUXGYzjFASXjdY7GNoFxvlkR54

[Anonymous]

Hi Amit,

Thanks a lot for your quick reply. I have applied your logic and awaiting the confirmation from one user. 

I will accept your solution ASAP if it works.

Thanks 

Rishabh