Forum

Formula working in ...
 
Notifications
Clear all

Formula working in Power Pivot but working in Power Bi

2 Posts
2 Users
0 Reactions
90 Views
(@jubaer007)
Posts: 5
Active Member
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 ?PowerBi.PNGPowerPivot.PNG
 
Posted : 06/04/2023 7:49 am
(@debaser)
Posts: 837
Member Moderator
 

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
Share: