I need a measurement that is calculated only if values are selected in a slicer

[Syndicate_Admin]

Dear Community,

I have 3 sizes, cost_enginehr_total, cost_fuel_total and cost_labor_total

But I need that the measurement cost_enginehr_total only be calculated for the machines that are selected in the slicer that I show below but that although I do not select any (and therefore that specific measure is not calculated) I can continue to observe the rest of the machines with the other two remaining measures cost_fuel_total and cost_labor_total.

Thank you for your support

[Syndicate_Admin]

Hola Arul,

Yes... what I try to look for is that specifically the measure "cost_enginehr_total" is only calculated for the machines you select in the slicer, while the other two measures should always be calculated... I attach a reference image that more less is what I am looking for...

[v-xiaotang]

Hi @Syndicate_Admin  @calonzo2078 

It looks like you only need to change cost_enginehr_total, try the following code and replace 1 with your calculated expression

Measure = IF(MIN('Table'[machine_name]) in ALLSELECTED(slicer), 1 ,BLANK())

Kindly note: put the column in slicer table into Slicer visual

Best Regards,

Community Support Team _Tang

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

[Syndicate_Admin]

Hello!!

Create a measure called "cost_enginehr_total_test" to test your solution and this is what results

Whereas the "slicer" comes from the "machine_name" column of the "machine" table

1. Here's what happens if I don't select any machines in the slicer:

2. If I select at least two "machine", it only shows me information of the selected machines

And I should show the information as it is seen in the test that you did previously with your proposed solution ..

What may be happening???

[Arul]

@Syndicate_Admin ,

Does this needs to be calculated for cost_enginehr_total while selection happens in the measure?

Thanks,

Arul

[Syndicate_Admin]

This is Arul...