Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have a matrix thathas one column value and is using multiple measures, one for each row/value. I have several slicers on the table and when the result of the measure is 0 or null, the matrix shows "--" for that value. My goal is that when all the results of a measure across the row are "--" all across the row, that the entire row will hide/filter itself out. Essentially, the number of rows that show at any given time should always be dependent on the values. If there are non 0/null values in the row, it should show. If every value is 0/null, it should hide.
Considerations/limitations:
I am essentially lookig to filter by measure/row to hide blank rows.
I am not sure it meets your criteria, but I have used NOT ( ISBLANK ( [Measure] ) ) in the DAX to not show rows that have blank values. In my case I also wanted to format numbers in millions without the M som my new measure was:
New measure =
Hi,
When I combined the measures into one formula and used it as a filter, it made every row in my matrix disappear and only left one, blank column.
Hi @madiaree
I don't think I can understand the problem based on a verbal description alone, so try downloading my file with the example and follow my steps. Or attach a sample file of your own as a link.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
83 | |
66 | |
60 | |
58 |
User | Count |
---|---|
194 | |
111 | |
105 | |
79 | |
71 |