Excel Forum

Formula working in Power Pivot but working in Power Bi

Jubaer Alam Sonet

Active Member

Members

Forum Posts: 5

Member Since:
February 4, 2021

Offline

April 5, 2023 - 9:49 pm

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 ?