Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi, I have a data as shown in picture.
i want a dynamic solution to filter out each category by the maximum size sold of each category.
for example, in data there are multiple luxury pret entries, i want to see which size is sold in highest qunatity.
kindly help me to do it in power BI
Solved! Go to Solution.
Hi @Mkhubaib ,
Create this rank measure, put it in the table visual filter and set its values as 1:
Rank =
RANKX (
ALLEXCEPT ( 'Table', 'Table'[Description] ),
CALCULATE ( SUM ( 'Table'[Qty sold] ) ),
,
DESC,
DENSE
)
Attached my sample file that hopes to help you, please check and try it: Filter out the max of each category.pbix
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Mkhubaib ,
Create this rank measure, put it in the table visual filter and set its values as 1:
Rank =
RANKX (
ALLEXCEPT ( 'Table', 'Table'[Description] ),
CALCULATE ( SUM ( 'Table'[Qty sold] ) ),
,
DESC,
DENSE
)
Attached my sample file that hopes to help you, please check and try it: Filter out the max of each category.pbix
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
@Mkhubaib , Create a Rank(measure) size and filter by one.
For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale
https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/3...
or use Top1 filter.
example
Top 10 City Rank = CALCULATE([Sales],TOPN(1,all(Geography[City]),[Sales],DESC),VALUES(Geography[City Id]))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
98 | |
81 | |
65 | |
62 |
User | Count |
---|---|
147 | |
116 | |
104 | |
88 | |
65 |