Create a Slicer

[anwargabr]

Gents,

I've a colum named company, includes A, B, C, D, E, and F companies.

I want to creat a slicer filter "Selection Table" with two selection "Consolidation and Consolidation withot F"

1- Consolidation : Group all companies in all calculations
2- Consolidation withot F, Group all companies except for F in all calculations

thanks,

[v-xinruzhu-msft · Accepted solution]

Hi @anwargabr 

You can refer to the following sample.

Sample data

Slicer data 

Then create a measure and put it to the table visual

Measure = IF(OR(ISFILTERED('Table (2)'[Slicer])=FALSE(),ISFILTERED('Table (2)'[Slicer])&&SELECTEDVALUE('Table (2)'[Slicer])="Consolidation"),CALCULATE(SUM('Table'[Column2])),CALCULATE(SUM('Table'[Column2]),FILTER('Table',[Column1]<>"F")))

 Output

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[olgad]

Hi, create a calculated column to classify your companies If(Company="F", "Conso without F", "Conso") 

You can use this column in all your further calculations if you need and as a slicer.