Forum Discussion

euro_sree's avatar
euro_sree
Regular Visitor
1 year ago

Facing problem with ABC Analysis. In the last two rows I am getting blank value for ABC Analysis

Hi Friends I am facing a problem when doing the ABC analysis. In the last two records I am not getting no value for ABC analysis. In the last two records the cost of the part is same therefore the R...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi euro_sree ,

 

I tried your DAX and it works fine.

 

ABC Analysis = 
SWITCH(
    TRUE(),
    PartInfo[CumulativeCostPercentage] <= 0.40, "A",
    PartInfo[CumulativeCostPercentage] <= 0.70, "B",
    PartInfo[CumulativeCostPercentage] <= 1, "C"
)

 

 

Please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.

Refer to:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

 

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.