Sum of each row with distinct name.

[Anonymous]

I've got a table like the picture below, default table in powerbi.

normal table

Is it possible to get a sum of each name in the table, like in the picture below?

is this possible? how?

Thanks for your help.

Best regards

Nick

[v-frfei-msft]

Hi @Anonymous,

We can create a matrix as below.

For more details, please check the pbix as attached.

Regards,

Frank

[Anonymous]

Hey @v-frfei-msft,

thanks for your answer and example. Sadly I cant seem to reproduce it. I compared your pbix and also tinkered in it, but I dont see how you did it. As I try it, I always end up with this:

Please explain how you did it. Thank you very much!

Edit: Nevermind I got it, I just had to expand the names.

Edit2: I see now that the example I chose was too simple.

What I really want is something like this:

But the row with the names should not contain anything in the "Desc." colums.

Best regards

Nick

[v-frfei-msft · Accepted solution]

Hi @Anonymous,

To create a measure to meet your requirement.

Measure = IF(ISINSCOPE(Table1[Date]),MAX(Table1[Desc]),BLANK())

Regards,

Frank

[Anonymous]

Thank you very much Frank!

[v-frfei-msft]

Hi @Anonymous,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards,

Frank