The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I have two data
Is there a way I can make the all in rate in the aggregrated row empty? because it's not meaningful (like when you expand it the all in rate will show A, B, C for example, but it's meaningless to aggregrate it)
Thanks!
@GAPER
If you need to hide values for certail level, then use the following pattern: In this example, if year and month are in a matrix on the Row, the measure will only show at month level
Measure Name =
IF(
ISINSCOPE( 'Date'[Month] ),
[Your Measure ]
)
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
I think you have one extra parenthesis at the end. Also may I check if this is going to be measure or column?
i am doing it as a measure but it's returning me an error like this
Thanks!!