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 PaulDBrown 
   
   Its working fine and when we are using the date filter range is not applicable on that total transaction count. how to make on that dax on date wise it's showing total transaction count. Interaction also fine.. so please sort me out. 

 

  • PaulDBrown's avatar
    PaulDBrown
    Community Champion
    5 years ago

    Anonymous 

    Please post an image of the model.