Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I've got a table like the picture below, default table in powerbi.
Is it possible to get a sum of each name in the table, like in the picture below?
Thanks for your help.
Best regards
Nick
Solved! Go to Solution.
Hi @Anonymous,
To create a measure to meet your requirement.
Measure = IF(ISINSCOPE(Table1[Date]),MAX(Table1[Desc]),BLANK())
Regards,
Frank
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
Hi @Anonymous,
To create a measure to meet your requirement.
Measure = IF(ISINSCOPE(Table1[Date]),MAX(Table1[Desc]),BLANK())
Regards,
Frank
Thank you very much Frank!
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
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |