Forum Discussion

Flori_Abb's avatar
Flori_Abb
Helper I
9 years ago

DAX Switch function with two variables

Dear all   just to collect some thoughts if that is a good way or if this formula will slow down my pbi report in future... I have two calculated values (Revenue/Units) and a calculated average ...
General Comment
v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago

Hi Flori_Abb,

From what I know, your formulas are nice, it's normal to run lower after you add more variables. I will post the update when I find more efficient way.

Best Regards,
Angelia

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft Employee
    9 years ago

    Hi Flori_Abb

     

    Not so much a performance tip, but I'd recommend using the DIVIDE function for your division maths.

     

    so rather than 

     

    z = x / y

    use

     

    z = DIVIDE(x,y,0)

    In terms of performance, can you preaggregate or precalculate some of your data upstream of Power BI?  eg in the Query Editor or in your data source?