Forum Discussion

BKnecht's avatar
BKnecht
Kudo Kingpin
9 years ago
Solved

Sum Unique Rows after Unpivot

I have a table with unique rows. I had to unpivot the table based on a column to get a value I was looking for. The problem is, after I unpivot the table, all of the other measures I would try to mak...
  • v-haibl-msft's avatar
    v-haibl-msft
    9 years ago

    BKnecht

     

    I’m not sure the visual/table you want now. If you just want to count the # Seats column for each unique row based on the ID column. Just create a new table with following formula.

     

     

    Best Regards,

    Herbert

Anonymous's avatar
Anonymous
Not applicable
9 years ago

BKnecht

Did you end up finding a solution?

 

You can always randomize some data and send us a dummy file, stripping out any confidential names or values.  We just need the table(s) in the same structure.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

BKnecht easiest way to share a problem query is to use a fake data source. This site makes it pretty easy to create dummy test data for such cases. Make something that looks like the important parts of your source data and run it through the same query steps to show us what you're attempting.

  • BKnecht's avatar
    BKnecht
    Kudo Kingpin
    9 years ago
    Anonymous wrote:

    BKnecht easiest way to share a problem query is to use a fake data source. This site makes it pretty easy to create dummy test data for such cases. Make something that looks like the important parts of your source data and run it through the same query steps to show us what you're attempting.

    Anonymous wrote:

    BKnecht easiest way to share a problem query is to use a fake data source. This site makes it pretty easy to create dummy test data for such cases. Make something that looks like the important parts of your source data and run it through the same query steps to show us what you're attempting.

    AnonymousAnonymous - Unfortunately I did not find a solution, I just brought in the table a second time (it isn't a big table). It's  not ideal because now I have to update 2 tables every month, but I had to get this dashboard out to leadership. 

     

    That mock data website is great - thanks for sharing. I've attached a PBIX file of what the table and query steps look like. What I'm trying to do is count the # Seats column for each unique row based on the ID column. So for example, the count of seats for ID 1 would be 20, and for 2 it would be 89, etc. 

     

    Again, the problem is now that I've unpivoted the data so there are multiple rows for each ID. Any suggestions? Thank you for the help!

     

    Stupid question - how do I attach the pbix file to this post? I don't see a file attachment option anywhere.

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      BKnecht I don't think there is a file upload option here. You'll have to put it on dropbox or google drive or something and give us a link.