Forum Discussion

MuppetyMe's avatar
MuppetyMe
Helper I
1 year ago
Solved

Slicer Help - Categorizations

Looking for assistance creating a slicer for a set of data, but I'm not even sure it's possible. Below is my sample set.    I want my slicer to have two options: "Pipeline" and "Revenue". This slic...
Need Help
  • MFelix's avatar
    MFelix
    1 year ago

    Hi MuppetyMe ,

     

    Create a disconnected table with the two values:

    Pipeline

    Revenue

     

    Then add the following measures:

    Total = SUM('Table'[ Amount ])


total Values = 

SWITCH(
    TRUE(),
         SELECTEDVALUE('Type Selection'[Type]) =  "Pipeline"  , [Total],
         SELECTEDVALUE('Table'[Status]) ="Won" && SELECTEDVALUE('Type Selection'[Type]) = "Revenue", CALCULATE([Total], 'Table'[Status] = "Won"))

     

     

    See PBIX attached.