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
Hereby the table of sample data and the wanted result for this data.
| Type | Reserved | Value |
| S0 | Yes | 50 |
| S0 | Yes | 10 |
| S0 | No | 15 |
| S1 | Yes | 100 |
| S1 | No | 10 |
| S2 | Yes | 200 |
| S3 | No | 120 |
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