Need Help with DAX Measure

Hi Power BI Community, I need help in Writing a DAX measure. I have 2 measures A, B and a Slicer Column C. If No Value or All or selected from Slicer, it should take value from Measure A ...

Need Help

v-janeyg-msft

5 years ago

Hi, Anonymous

You can try:

measure =
SWITCH (
    TRUE (),
    DISTINCT ( Input[Customer] ) = BLANK ()
        || DISTINCT ( Input[Customer] ) = DISTINCT ( ALL ( Input[Customer] ) ), SUM ( Input[Customer Mix] ),
    [Fx Customer Mix]
)

Best Regards

Janey Guo

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