Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
I am creating a matrix that includes a row hierarchy. I'll call the two subcateories Category1 and Category2. The total member count for each subcategory should be the same. However, I would only like to display one of the values since it looks quite repetitive. I don't want the value to be aligned with either Category1 or Category2, but I would like it to be displayed aligned with the outer-measure, Year. Here is what it looks like when I expand the hierarchy. Any tips?
Solved! Go to Solution.
Hi @Anonymous ,
Please have a check this way.
Measure 2 =
IF (
ISINSCOPE ( 'Table'[category] ),
BLANK (),
DIVIDE (
CALCULATE ( SUM ( 'Table'[Member count] ) ),
DISTINCTCOUNT ( 'Table'[category] )
)
)
Hi @Anonymous ,
Please have a check this way.
Measure 2 =
IF (
ISINSCOPE ( 'Table'[category] ),
BLANK (),
DIVIDE (
CALCULATE ( SUM ( 'Table'[Member count] ) ),
DISTINCTCOUNT ( 'Table'[category] )
)
)
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 98 | |
| 72 | |
| 50 | |
| 49 | |
| 42 |