Forum Discussion

msalahkar's avatar
msalahkar
Frequent Visitor
6 years ago

Adding a column with fixed value in matrix

Hi,    I am creating a P&L in matrix and along with the amount column i want to add a percentage column which divides row value with total revenue. therefore I want to calculate a measure which sho...
Need Help
v-lionel-msft's avatar
v-lionel-msft
Community Support
6 years ago

Hi msalahkar ,

 

My understanding is that you need to ignore the filters on [Account Head] column and [Account_Subcategory_Descript] column and sum by [Fiscal Quarter] column, is that right?

Try this measure again:

Measure 2 = 
CALCULATE(
    SUM(General_Ledger_Entries[Correct Amount),
    ALL(Chart_of_Accounts,Chart_of_Accounts[AccountHead],Chart_of_Accounts,Chart_of_Accounts[Account_Subcategory_Descript]),
    ALLEXCEPT(
        General_Ledger_Entries,
        General_Ledger_Entries[Fiscal Quarter]
    )
)

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

msalahkar's avatar
msalahkar
Frequent Visitor
6 years ago

hi v-lionel-msft 

 

Thanks for your effort but that is not working as well. I guess what I am asking for might not be possible at the moment in power BI.

 

Thanks for your help though!!