Forum Discussion
Solved
How To Ignore Column Value in a Measure
Hello, I'm having a Matrix that holds values in the rows and in a column weather Yes or No the value was Budgetted. We are Showing the % of the Row Value. But now I would also display the total ...
Hi LeboeufHarry
If I understood you correctly you can use the measures :base_sum = sum('Table'[Value])Yes(%) = divide(CALCULATE([base_sum],'Table'[Reserved]="yes"),[base_sum])No(#) = divide(CALCULATE([base_sum],'Table'[Reserved]="no"),[base_sum])And put them in the table visual :
The pbix is atached
Even a better solution ! KR.
Happy to help 🙂