Displaying two measures in the slicer in the visual

[niteshtrehan89]

Hi All,

I have a urgent requirement in which I have created the two measures. 

Projectvalue= Sum(projectvalue)

Forecast= Sum(forecast)

Now i want to plot a bar chart with projectvalue, forecast and both. I have created a table named as Measure having three rows(Projectvalue, Forecast, Both)

I have created the selected measure for forecast and project value and it working perfecting fine. What to do if I need to showcase both the measure using the Both in the slicer.

Selected Measure = SWITCH(TRUE(),SELECTEDVALUE('Measure'[Measure])="Project Value",sum(data[Project Value]),SELECTEDVALUE('Measure'[Measure])="Forecasted Project Value",SUM(data[Forecasted Project Value]),SELECTEDVALUE('Measure'[Measure])="Both",SUM(data[Project Value]) && SUM(data[Forecasted Project Value]))

Thanks

[v-robertq-msft · Accepted solution]

Hi, @niteshtrehan89 

According to your description, you want to display the sum of values according to the selection of Slicer, you can try my steps:

1. Create a table ‘Slicer’ for the Slicer:

2. Create two measures:

Sum of Project Value =

SWITCH(

    SELECTEDVALUE(Slicer[Name]),

    "Project Value",SUM('Measure'[Project Value]),

    "Forecasted Project Value",BLANK(),

"Both",SUM('Measure'[Project Value]))

Sum of Forecasted Project Value =

SWITCH(

    SELECTEDVALUE(Slicer[Name]),

    "Project Value",BLANK(),

    "Forecasted Project Value",SUM('Measure'[Forecasted Project Value]),

"Both",SUM('Measure'[Forecasted Project Value]))

3. Create a slicer and a column chart, like this:

And you can get what you want.

You can download my test pbix file here

If this result is not what you want, you can post some sample data(without sensitive data) and your expected result.

How to Get Your Question Answered Quickly 

Best Regards,

Community Support Team _Robert Qin

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

[amitchandak]

@niteshtrehan89 , measure slicer is the measure itself so only measure can be there.

So both measures need to check the value of slicer

example

Projectvalue =
var _flag = countx(allselected(Measure), 'Measure'[Measure] in {"Project Value","Both"})+0
return
if(_flag>0, sum(data[Project Value]), blank())

Forecast =
var _flag = countx(allselected(Measure), 'Measure'[Measure] in {"Forecasted Project Value","Both"})+0
return
if(_flag>0, sum(data[Forecasted Project Value]), blank())