Dynamic Pareto table based on cumulative %

Hi k_swathi2001 ,

Please check "Field parameters" in Preview features.  Then restart Power BI for the function to take effect.

Please try following DAX to create three measures:

Grade(80/20 %) = SWITCH(
    TRUE(),
    MAX('Table'[Cumm Pct])<=0.6,"A+",
    MAX('Table'[Cumm Pct])>0.6 && MAX('Table'[Cumm Pct])<=0.8,"A",
    MAX('Table'[Cumm Pct])>0.8 && MAX('Table'[Cumm Pct])<0.9,"B","C")

Grade(70/30 %) = SWITCH(
    TRUE(),
    MAX('Table'[Cumm Pct])<=0.3,"A+",
    MAX('Table'[Cumm Pct])>0.3 && MAX('Table'[Cumm Pct])<=0.7,"A",
    MAX('Table'[Cumm Pct])>0.7 && MAX('Table'[Cumm Pct])<0.9,"B","C")

Grade(60/40 %) = SWITCH(
    TRUE(),
    MAX('Table'[Cumm Pct])<=0.4,"A+",
    MAX('Table'[Cumm Pct])>0.4 && MAX('Table'[Cumm Pct])<=0.6,"A",
    MAX('Table'[Cumm Pct])>0.6 && MAX('Table'[Cumm Pct])<0.9,"B","C")

Click "Modeling"-"New parameter"-"Fields".

Check three measures and click "Create".

You will get a field parameter like below:

Create a slicer using field parameter and create a table visual using ID column and field parameter.

You can change the 80/20 % and check to see Product grade based on 70/30 or 60/40. 

Best regards,

Yadong Fang

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