Forum Discussion
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...
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.
Hi,
PBI file attached.
Hope this helps.
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.
Thank you MFelix and Ashish_Mathur! Both of your suggestions (almost the same, but slightly different) solved my issue. Appreciate your time and help!