Forum Discussion

anwargabr's avatar
anwargabr
Helper I
3 years ago
Solved

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" ...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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.