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

     

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?

  • 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

         

         

  • 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.