Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Reflecting slicers from GUI in a table of measures

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?

 

 

2 REPLIES 2
amitchandak
Super User
Super User

@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

 

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Anonymous
Not applicable

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.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.