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.
Reported Splits on Bar Chart with drill down ability to get form DMA to City | |||
DMA (Denver Selected) | Distribution of DMA (Denver) | City (in Denver) | Distribution of City (in Denver) |
Denver | 235 | Denver | 70 |
Denver | 235 | Littleton | 30 |
However, I want to put a limit on showing each DMA or City based on if they pass the distribution rule when it is also split by market so pub and cafe for example.
Littleton For example passes Distribution > 30 at a more granular level so is showing on my bar chart.
However, when split by market Littleton bars < 30 and Littleton Cafes < 30 so I do not want Littleton to show on my bar chart but i want to be able to do this without putting market in my ledgend or showing on the chart at all, just a filter or some kind of calculated column maybe?
Thanks in advance! 🙂
Solved! Go to Solution.
Thanks all,
I figured this out using a SUMX
Thanks all,
I figured this out using a SUMX
I'm not at all clear on this. You could use the Filter pane to get rid of cities.
If you absolutely, positively have to do it in DAX, you can start your DAX code with something like:
Measure =
VAR __Table = FILTER('Table',[City] <> "Some city" && [City] <> "Some other city")
Then perform your calculations against __Table
Or, at the end of your measure you could do something like:
RETURN
IF(MAX('Table'[City]) = "Some city" || MAX('Table'[City]) = "Some other city",BLANK(), <whatever calculation>
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 |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
44 | |
32 | |
30 | |
18 | |
17 |