Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have a report with som slicers. When I add a measure to the corresponding imported table with diiferent rowcounts the slicers are reflected in the rowcounts.
But if i define the same measures in a table and present the together with them the slicers choices are not reflected
Definition of Measures in Tableresult
MeasureCount1 = COUNTROWS(FILTER('Tableresult',('Tableresult'[Atribute1]="Y")))
MeasureCount2 = COUNTROWS(FILTER('Tableresult',('Tableresult'[Atribute2]="Y")))
Definition of TableOfMeasures:
DiffCount TableOfCounts =
UNION(
ROW ("Name","Count1", "Count", 'Tableresult'[MeasureCount1]),
ROW ("Name","Count2", "Count", 'Tableresult'[MeasureCount2])
)
Measurecount1 and Measurecount2 presented in a Card visual
When Slicer1 is sliced with an attribute there MeasureCount1 and MeasureCount1 are reduced to reflect the resultset in Tableresult
Measurecount1 and Measurecount2 presented in a Table visual using TableOfMeasures
MeasureCount1 and MeasureCount2 do not reflect Slicer1
How do I scope the measures in the table TableOfMeasures to reflect the Slicer1 choices?
@Anonymous , Do you need a measure slicer?
You need an independent table with just measure name
If yes, refer to these
measure slicer
https://www.youtube.com/watch?v=b9352Vxuj-M
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slicer-parameter-table-pattern
Hi and thanks for your reply
I need the slicers, actually I have between 10-30 slicers in each report. The report is for testing purposes to capture error between two environment, one slicer pr column in a view. The measures counts error of one particularar column. I also have slicers that sort the records on different types to find patterns of errors. If i.e. the Type Slicer is slicing type A I want the measures to reflect only records of Type A.
And in addition to the Type slicer I need functionality for the users to slice errors for each column so that they can study similarities for one error type over many records. Those choices should also be reflected in the measures.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
24 | |
10 | |
6 | |
6 | |
6 |
User | Count |
---|---|
29 | |
11 | |
11 | |
10 | |
6 |