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 

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 

 

 

 

  • 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