topic using DAX to Grade Percentages in DAX Commands and Tips

using DAX to Grade Percentages

Anonymous — Wed, 18 Jan 2023 13:10:53 GMT

I am scoring data quality of some product data. based on percentage differences between actual data and what the supplier has given me. in excel I would use the IFS function

=IFS(D21<0.9,"F",D21<=1,"A",D21<=0.96,"B",D21<=0.93,"C")

How can I do this in DAX.

Thx in advance

Re: using DAX to Grade Percentages

Anonymous — Wed, 18 Jan 2023 13:30:03 GMT

Hi Anonymous ,

As per my understanding, I have tried to answer your question.

Flag = IF(Sheet1[Difference]<0.9,"F",IF(Sheet1[Difference]<=1,"A",IF(Sheet1[Difference]<=0.96,"B",IF(Sheet1[Difference]<=0.93,"C"))))

Best Regards,
Shreya

Did I answer your question? Mark my post as a solution!

Appreciate with a Kudos!! (Click the Thumbs Up Button)

Re: using DAX to Grade Percentages

Anonymous — Wed, 18 Jan 2023 15:42:17 GMT

I managed to sort it using SWITCH(TRUE().

Grades: = SWITCH(TRUE(),'VELU001_Weights_Graded'[VELU001_Audited_Weight_Difference]<=0.04,"A",'VELU001_Weights_Graded'[VELU001_Audited_Weight_Difference]<=0.07,"B",'VELU001_Weights_Graded'[VELU001_Audited_Weight_Difference]<=0.1,"C",'VELU001_Weights_Graded'[VELU001_Audited_Weight_Difference]>0.1,"Fail")
Thanks for your swift reply and help
😊