Switch True DAX measure not returning correct results

[Anonymous]

Hi Expert

i am not getting the correct result for Managed Services and Professional Services when using the Switch funtion in the below DAX - would expect MS to be 7% Higher then the [Sales Forecast] but its not.

Forecast Test 1 =

Switch(TRUE(),

max(FACT_NEWBI_NewSalesDashboard[OrderType]) = "Managed Services" , [Sales Forecast]*1.07,

max(FACT_NEWBI_NewSalesDashboard[OrderType]) = "Professional Services" , [Sales Forecast]*1.08,

[Sales Forecast]

)

[harshnathani]

Hi @Anonymous ,

The DAX looks correct. Can you share a screenshot of the result the DAX is returning.

Forecast Test 1 =
SWITCH (
    TRUE (),
    MAX ( FACT_NEWBI_NewSalesDashboard[OrderType] ) = "Managed Services", [Sales Forecast] * 1.07,
    MAX ( FACT_NEWBI_NewSalesDashboard[OrderType] ) = "Professional Services", [Sales Forecast] * 1.08,
    [Sales Forecast]
)

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[Anonymous]

Hi harsh....see scren image there should be a difference by 7 & 8 percent but the number are the same. for MS and PS

[harshnathani]

Hi @Anonymous ,

Looks great. Can you share a sample of the .pbix file.

Also, did you try TRIM and CLEAN in POWER Query.

Regards,

Harsh Nathani

[Anonymous]

Hi Harsh ....sorry cannot upload file even sample duw to upload restrictions - below is another measure i tried and does also not work.. I have check for space using TRIM and Clean and we are good....

Measure 2 = 

Sumx( Values(FACT_NEWBI_NewSalesDashboard[OrderType]) ,

[Sales Forecast]*Switch(TRUE(),

max(FACT_NEWBI_NewSalesDashboard[OrderType]) = "Managed Services" , 1.07,

max(FACT_NEWBI_NewSalesDashboard[OrderType]) = "Professional Services" , 1.08,

[Sales Forecast]) )

[harshnathani · Accepted solution]

HI @Anonymous ,

Tried this on a sample Data.

Regards,

Harsh Nathani

[Anonymous]

Thanks Harsh - Excellent feedback sir, much appericated....