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
Community Champion
5 years ago

Anonymous 

For slicers to work, you have to enable interactions between the slicer and the visual(s).

 

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi 
   Am also tried your measure, but am not getting total value. please sort me out