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 dax side. please sort me out 


Output 


 

 

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

     

8 Replies

  • PaulDBrown's avatar
    PaulDBrown
    Community 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
        Community Champion
        5 years ago

        Anonymous 

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