Hi @freemainia ,
Create a calculated colum to pikcup any of the rating per requirement and then compare it against the rating in a row. If the rating vs the random rating is the same, return 1 else 0.
Rating Check =
VAR rating =
MAX ( 'Table'[Rating] ),
FILTER ( 'Table', 'Table'[Requirement] = EARLIER ( 'Table'[Requirement] ) )
IF ( 'Table'[Rating] = rating, 0, 1 )
Create another calculated column to get the sum of Rating Check (calculcated column previous created) per requirement. If the sum if zero then constentent = yes else no
SUM ( 'Table'[Rating Check] ),
ALLEXCEPT ( 'Table', 'Table'[Requirement] )
) > 0,
Then in a visual, get the distinct count of requirement split between whether it is consistent or not.
Please see attached pbix for details
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."