Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

DAX Issue

Hi Everyone         Am having user wise so many brand are there in inside table . so my requirement is user wise how many transaction done it . i want total transaction(Measure). am struggled on d...
data protection
Interesting Links
Need Help
Show and Tell
  • PaulDBrown's avatar
    PaulDBrown
    5 years ago

    Anonymous 

    Try these measures:

    BrandTxn = COUNT('Table'[Brand Name])
    Total TXN =
CALCULATE (
    DISTINCTCOUNT ( 'Table'[TXN ID] ),
    ALLEXCEPT ( 'Table', 'Table'[User ID] )
)

     

PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
5 years ago

Anonymous 

Try these measures:

BrandTxn = COUNT('Table'[Brand Name])
Total TXN =
CALCULATE (
    DISTINCTCOUNT ( 'Table'[TXN ID] ),
    ALLEXCEPT ( 'Table', 'Table'[User ID] )
)

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi PaulDBrown 

                 Its working but some filters also not applied. i want when i click on that single brand name its showing only that brand name and total txn count.
    But you given that measure its shwoing all userid and all values 

     




    • PaulDBrown's avatar
      PaulDBrown
      Icon for Community Champion rankCommunity Champion
      5 years ago

      Anonymous 

      Do you have the interactions enabled between the slicer and the table?

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hi 
          Am not use any interactions. when am use these measures am getting full data that date filter also not working so we are getting some mismatch data. please sort me out. i want output is 20