Reflecting slicers from GUI in a table of measures

[Anonymous]

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?

[amitchandak]

@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

[Anonymous]

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.