Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.
Hi All,
Please help me with the correct sum in the table. While using rank I would like to see sum only for selected products. Thx.
Solved! Go to Solution.
I have managed with it already by such measure:
I have managed with it already by such measure:
Hi @termini,
I am not exactly sure why you are using the TopN table but I used these formulas to replicate your data:
Rank by Sales = RANKX('Table','Table'[Value],,DESC)
Rank If = IF('Table'[Rank by Sales]<=3,'Table'[Value])
I used these two along with the Product and Value column and got the right total.
Works for you? Mark this post as a solution if it does!
Consider taking a look at my blog: Forecast Period - Previous Forecasts
unfortunatelly this measure
Rank by Sales = RANKX('Table','Table'[Value],,DESC)
gives me rank of 1 in each line (for each product)
Hi , @termini
For your rankx , you need to use this dax :
Rank by Sales= RANKX( ALL('Table'[product]) ,CALCULATE( SUM('Table'[val])),,DESC)
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
72 | |
67 | |
65 | |
42 | |
42 |
User | Count |
---|---|
46 | |
40 | |
28 | |
27 | |
26 |