Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Report Table View Different from Data View

I have a table which can have duplicate transaction ID's because of manual comments that can be made by the user. My problem is that the measure that I created is correctly counting the transaction I...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    5 years ago

    I found my own solution by updating the inner measure [Transaction Count]. This will summarize transactions that have the same comment but individually count transactions that have distinct comments.

    [Transaction Count] =
COUNTROWS(
    SUMMARIZE(
        Transactions,
        Transactions[trans_id],
        Transactions[comments]
    )
)

     

KNP's avatar
KNP
Super User
5 years ago

Hi Anonymous - What is the calculation for [Transaction Count]?

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    KNP sorry...I forgot to add that. The calculation for Transaction count = COUNT( trans_id )

     

    Thank you for your support

    • KNP's avatar
      KNP
      Super User
      5 years ago

      Possibly, DISTINCTCOUNT( trans_id ) will work, depending on what else you're using that measure for.

       

      Edit: may need to see data model with relationships if it isn't that simple.

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        KNP I tried DISTINCTCOUNT( trans_id ) but that did not work well. If you look at "Expected Report Table Output", using DISTINCTCOUNT( trans_id ) will only give 1 count for trans_id = 3.