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

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. 

  • KNP's avatar
    KNP
    Super User
    5 years ago

    I think I need to see a more complete set of data and the model with relationships. 

    My gut feeling, I'd be doing more data modelling in Power Query and possibly separating out the comments or concatenating them into one column, but I'm guessing at this point.