The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 .
Solved! Go to Solution.
@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
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Okay !! thank you so much !
@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
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
User | Count |
---|---|
25 | |
12 | |
8 | |
8 | |
7 |
User | Count |
---|---|
27 | |
12 | |
12 | |
12 | |
6 |