Solved: To find number of name after 80% in pareto chart

Anonymous · ‎05-28-2022

Hello guys, I have created a pareto chart as shown below. May I know is there any other way for me to create card or any other visual to know the distinct count of name that is appear after 80% inside the pareto chart ? Thank you so much .

Fowmy · ‎05-28-2022

@Anonymous

Create the following measusre to count the number of names that fall the mark of above 80% and drop it ina card visual

Count Above 80% =
VAR __NAMEPARETO =
    ADDCOLUMNS ( VALUES ( Table[Supplier Name] ), "Pareto", [Cumulative %] )
VAR __COUNT =
    SUMX ( __NAMEPARETO, INT ( [Pareto] > 0.8 ) )
RETURN
    __COUNT

Did I answer your question? Mark my post as a solution! and hit thumbs up

⭕ Subscribe and learn Power BI from these videos

⚪ Website ⚪ LinkedIn ⚪ PBI User Group

View solution in original post

Anonymous · ‎05-28-2022

Okay !! thank you so much !

Fowmy · ‎05-28-2022

@Anonymous

Create the following measusre to count the number of names that fall the mark of above 80% and drop it ina card visual

Count Above 80% =
VAR __NAMEPARETO =
    ADDCOLUMNS ( VALUES ( Table[Supplier Name] ), "Pareto", [Cumulative %] )
VAR __COUNT =
    SUMX ( __NAMEPARETO, INT ( [Pareto] > 0.8 ) )
RETURN
    __COUNT

Did I answer your question? Mark my post as a solution! and hit thumbs up

⭕ Subscribe and learn Power BI from these videos

⚪ Website ⚪ LinkedIn ⚪ PBI User Group