Forum Discussion
Create a Slicer
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,
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.
2 Replies
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.
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.
