Forum Discussion

nutdiablo's avatar
nutdiablo
Frequent Visitor
7 years ago
Solved

How to get count by group?

Dear Everyone,

Sorry for my bad English. I got Table Revenue and Location as picture below.
When I merge 2 tables together revenue got duplicated. So I need column D so I can divine the number back to normal.
Please advice.

  • nutdiablo's avatar
    nutdiablo
    7 years ago

    I have found the solution.

    I user merge with aggregate then merge again to break it into details.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    What is this, a DAX- or PQ-related question? If it's PQ, please find the forum on PQ.

     

    If it's about DAX... then what do you mean by "merging tables"?

     

    Thanks.

     

    Best

    Darek

  • nutdiablo's avatar
    nutdiablo
    Frequent Visitor
    7 years ago

    I have found the solution.

    I user merge with aggregate then merge again to break it into details.