Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
Check it out now!Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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.