Forum Discussion

LeboeufHarry's avatar
LeboeufHarry
Icon for Helper I rankHelper I
2 years ago
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 ...
Need Help
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    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