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 else from Measure B.

 

Thanks in advance.

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.

7 Replies

  • BA_Pete's avatar
    BA_Pete
    Icon for Super User rankSuper User
    5 years ago

    Hi Anonymous ,

     

    Try this measure:

    _variableOutput =
IF(
  HASONEVALUE(slicer[column C]),
  [measure B],
  [measure A]
)

     

    Pete

    • 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])

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Icon for Community Support rankCommunity Support
    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.