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.
I have a table in power BI that looks like this:
Customer | Revenue | Rank | Cumulative % of Revenue |
A | 5,620 | 8 | 13.4% |
B | 5,146 | 10 | 16.0% |
C | 5,122 | 10 | 16.0% |
I have a filter on this visual that says "Revenue is not blank".
When I clear that filter, I get a bunch of blank entries at the end, but the ranking and cumulative corrects itself.
Here is my Ranking formula:
@cbolling , This Rank formula seems fine. Are having Revenue formula like
revenue = sum(Table[sales])+0 // of handled blank
Also Cumalative should use allselcted like
Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected(date),date[date] <=maxx(date,date[date])))
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
I have fixed the previous problem from pulling customer from the customer table, rather than our sales table.
Now there is a new problem. This file seems to be taking up too much computing power as this customer table is rather large, and all the measures are built off of each other.
TOTALREVENUE = SUM(FactSales[revenue])
Rank = RANKX(ALLSELECTED(DimCustomer[Customer]), [TOTALREVENUE],,Desc,Skip)
THis is the error message I am getting when I use the customer table.
The relationship from FactSales to DimCustomer is Many to One
Also, when I use "Skip" instead of "dense" the problem is still there
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 |
---|---|
43 | |
23 | |
21 | |
15 | |
15 |
User | Count |
---|---|
45 | |
31 | |
30 | |
18 | |
17 |