Help with conditional measure based on filter selection

[plaralema]

Hello, i need some help with a measure, it has to be conditional depending on a filter selected

There are 4 elements: Copper, Zinc, Arsenic and Silver. (used as a PAGE filter, unique selection)

Measure is this:   

Chemical_composition_efect = (([Composition2023]-[Composition 2022])/100)*[Feed2023]*([Recovery2022]/100)

But it would only work for Copper and Arsenic, because composition 2023-2022 are in % unit, Zinc and Silver are in ppm base so measure should be if zinc or silver are selected.

Chemical_composition_efect = (([Composition2023]-[Composition 2022])/100000)*[Feed2023]*([Recovery2022]/100)

how can i create a measure with conditional based on a filter selected? thanks in advance.

[plaralema]

Thank you so much, it worked !! thanks a lot 😄 

[lukiz84 · Accepted solution]

Hi,

Chemical_composition_efect = 

VAR selected = SELECTEDVALUE(Element[Name]) 
VAR divisor = IF(selected = "Zinc" || selected = "Silver", 100000, 100)

RETURN
(([Composition2023]-[Composition 2022])/divisor)*[Feed2023]*([Recovery2022]/100)

where Element[Name] is your slicer, please change for your names 🙂