Forum Discussion

swarnalvr's avatar
swarnalvr
Frequent Visitor
1 year ago
Solved

Dax measure

Hi  I am using matrix table and there is sales1 and sales2, iam dynamically selecting those measures from drop down slicer I have used "difference "= sales1-sales2 which runs when both are selected...
Need Help
  • BeaBF's avatar
    BeaBF
    1 year ago

    swarnalvr ok, so try with:

    Difference =
    IF(
    ISINSCOPE(Sales2),
    Sales1 - Sales2,
    BLANK()
    )

     

    BBF

BeaBF's avatar
BeaBF
Super User
1 year ago

swarnalvr Hi! try with:

Difference =
IF(
NOT ISBLANK(SELECTEDVALUE(Sales2)),
Sales1 - Sales2,
BLANK()
)

 

BBF

swarnalvr's avatar
swarnalvr
Frequent Visitor
1 year ago

Thanks but both sales1 and sales 2 are measures..so selected value not working

  • BeaBF's avatar
    BeaBF
    Super User
    1 year ago

    swarnalvr ok, so try with:

    Difference =
    IF(
    ISINSCOPE(Sales2),
    Sales1 - Sales2,
    BLANK()
    )

     

    BBF

    • BeaBF's avatar
      BeaBF
      Super User
      1 year ago

      swarnalvr if you can paste some sample data and the measures, i can help you better.

       

      BBF