Forum Discussion
Solved
Generate cummulative table
Hello dear Power BI-Community
Following problem to solve:
Let's assume this table
| Person | Rating given |
| A | good |
| A | bad |
| A | bad |
| B | good |
| B | bad |
| C | bad |
| C | bad |
| D | bad |
| E | good |
I would love to crate this table
| person_num | ratings_given_bad | |
| 2 | 1 | |
| 2 | 2 |
The table shows:
2 Persons gave 1 bad rating (Person B & D)
2 Persons gave 2 bad rating (Person A & C)
Is there any way to generate a Table like this?
Thank you very much for your contribution.
Cheers
qwertzuiop
qwertzuiop , It seems like a case of dynamic Segmentation
Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ
1 Reply
qwertzuiop , It seems like a case of dynamic Segmentation
Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ