Generate cummulative table

[qwertzuiop]

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

[amitchandak · Accepted solution]

@qwertzuiop , It seems like a case of dynamic Segmentation

Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ