79362398

Date: 2025-01-16 16:36:58
Score: 1
Natty:
Report link

The primary rule of thumb is PBI does NOT like 2-d dataset; unpivot it.

enter image description here

The measure itself is not complex,

Check = 
FORMAT (
    IF (
        HASONEVALUE ( DATA[Profile] ),
        MAXA ( DATA[Value] ),
        DISTINCTCOUNT ( DATA[Value] ) - 1
    ),
    "\Y;;\N"
)

enter image description here

The tricky part is how to make use of "Column subtotals" of Matrix viz to display the result,

enter image description here

Reasons:
  • Probably link only (1):
  • Has code block (-0.5):
  • Low reputation (0.5):
Posted by: ThxAlot