Notifications
Clear all
Topic starter
I am facing a problem with a power pivot and power bi formula. In one column i have Revenue, Cos, Admin, other value in the other column i want to see the total revenue value only like below. what formula to use in power bi? You can see in the power pivot screen shot its showing revenue figure in all the row irrespective of the category/condition but in power bi formula its not showing and its showing only where in the category revenue column row only not other category row i need this as i want to find out which cost what % of revenue. I used the formula
Rev = CALCULATE(SUM('PnL Conso'[USD Net Balance]),'PnL Conso'[Financial Statements]="Revenue",ALL('PnL Conso'[Group Head]), ALL('PnL Conso'[Account Head2]),ALLSELECTED(DimCountry[Tracker Country]))
In my file there are slicer for country, year and month also.
Can anyone help how to modify this formula ?

Posted : 06/04/2023 7:49 am
Are you sure you're using the same fields in the matrix in PowerBI as in your PP pivot table? Can't really tell much from those pictures.
Posted : 06/04/2023 10:09 am