DAX Issue

[Anonymous]

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 

[PaulDBrown · Accepted solution]

@Anonymous 

Try these measures:

BrandTxn = COUNT('Table'[Brand Name])

Total TXN =
CALCULATE (
    DISTINCTCOUNT ( 'Table'[TXN ID] ),
    ALLEXCEPT ( 'Table', 'Table'[User ID] )
)

[Anonymous]

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]

@Anonymous 

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

[Anonymous]

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]

@Anonymous 

Please post an image of the model.

[Anonymous]

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]

@Anonymous 

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

[Anonymous]

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