Power BI - Count of Created Cases by Creator Id, but visualized under Owner ID

[Simon_HJ]

Hey All,

I've been strugling with this issue for the past days with a Power BI issue and I've tried pretty much everything that I can think of. I have two columns in my fact table with ID's. OwnerID & Creator ID.

Now I want a measure (to be able to filter the result on specific dates) which shows me how many times a OwnerID has created a case. I've included a picture with two tables, the one to the left is how it currently looks, and I want it to look as it does to the right (with the Created Total column). I quickly withdrew the data and visualized this in excel for privacy reasons. 

Super greatful for any tips or solutions!

[DOLEARY85]

Hi,

for your created total you could create a calculated table to work it out then join it back to the Owner:

Table 2 = SUMMARIZE('Table (2)','Table (2)'[Creator],"Created Total",SUM('Table (2)'[Handled]))

and this should work as a calculated column for created by owner:

Created By Owner = CALCULATE(SUM('Table (2)'[Handled]),'Table (2)'[Owner]='Table (2)'[Creator])

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

[Simon_HJ]

Hey,

Thanks for your reply. This solutions gave me the total amount of cases for each ID in total. 
I'm looking for a solution where it's dynamic and I can filter it via dates and such. 

I managed to solve it through a bit of trickery in PQ, so now I have it the way I want!
Thank you for your help though!