Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I have a matrix report with [Rooms] in rows, [Program] in the pivot column, and [AreaM] for the value.
I have slicers to change the number of columns displayed [Programs] .
I want to filter out rows, where the columns all display zero. So I created a calculated column [AllProgramSum] to "sum up the columns". Yet, this calculation does not seem to correspond to the slicer(s). When I expect this calculated column to be zero, it shows the sum from all the columns...
Please advise, how to fix my calculated colunn:
In this screen shot, I would like to filter out all of the rows, where the three columns are all red (0.00).
Solved! Go to Solution.
@MarkusEng1998 Calculated columns are only calculated at data load and thus are not interactive. You would need something like a measure.
Thanks, @Greg_Deckler . I am making this more complicated than necessary. This simple measure fixed my issue:
Thanks, @Greg_Deckler . I am making this more complicated than necessary. This simple measure fixed my issue:
@MarkusEng1998 Calculated columns are only calculated at data load and thus are not interactive. You would need something like a measure.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
140 | |
71 | |
64 | |
52 | |
50 |
User | Count |
---|---|
209 | |
92 | |
64 | |
59 | |
56 |