Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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's avatar
    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.

gabrielreversi's avatar
gabrielreversi
Frequent Visitor
5 years ago

Hi Anonymous 

what do you look for would be that way?

 
 

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

     

    Hi Power BI Community,

     

    If All Values or No Values are selected from Customer Slicer, the above table should use Customer Mix Column, else it should use Fx Customer Mix Column.

     

    Please help, thanks in advance.

     

    Thank you

    Kuber Kumar

    • gabrielreversi's avatar
      gabrielreversi
      Frequent Visitor
      5 years ago

      Hi Anonymous 

       

      You use next measure:

       

      measure = 

      SWITCH(TRUE,

      ISFILTERED(table[customer]), [Fx Customer Mix], [Customer Mix])

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        gabrielreversi Thank you for the quick response, I tried the measure, it is not giving the expcected result.

         

        Please find both the images below