Forum Discussion
Help with conditional measure based on filter selection
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.
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 🙂
2 Replies
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 🙂