We're giving away 30 tickets for FREE! Share your story, your vision, or your hustle and tell us why YOU deserve a ticket.
Apply nowWin a FREE 3 Day Ticket to FabCon Vienna. Apply now
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!!
User | Count |
---|---|
64 | |
59 | |
46 | |
35 | |
32 |
User | Count |
---|---|
85 | |
83 | |
70 | |
49 | |
46 |