Forum Discussion
Matrix with multiple measures - disable drilldown only for one measure
Hello,
I have a matrix with three measures in the values tab and I need to disable the drill down for one of the measures. Is this possible? Thank you.
7 Replies
- parry2k
Super User
Anonymous not sure what you mean? You mean when you drilling into the rows, at next level you don't want to see the value for the measure? Provide bit more context. Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490Hello parry2k ,
I have attached an image to illustrate my situation. The Budget and Variance measures need to be displayed only at total level, and not split by account, as in the second photo.
- AllisonKennedy
Community Champion
Anonymous
Is budget and variance already a MEASURE as you say? If so please can you share the DAX formula you are currently using for these two measures? You could achieve this by focusing on the Measures totals, and add an IF statement into the measure such as :
BudgetNoDrill = IF(HASONEVALUE(Table[Account]), BLANK(), [Budget])
