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.

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

     

    • gabrielreversi's avatar
      gabrielreversi
      Frequent Visitor
      5 years ago

      You will need dimension table dCustomer and build the measure using that dimension table.

       

      This time using HASONVALUE.