using DAX to Grade Percentages

[Anonymous]

Hi

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

[shreyamukkawar]

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)

[Anonymous]

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
😊