
Jubaer Alam Sonet
Active Member
Members

Forum Posts: 5
Member Since:
February 4, 2021
February 4, 2021

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.
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online:
Guest(s) 10
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 873
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 222
Jessica Stewart: 216
A.Maurizio: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Melanie Ford
Isaac Felbah
Adele Glover
Hitesh Asrani
Rohan Abraham
Anthony van Riessen
Erlinda Eloriaga
Abisola Ogundele
MARTYN STERRY
Rahim Lakhani
Forum Stats:
Groups: 3
Forums: 24
Topics: 6356
Posts: 27793
Member Stats:
Guest Posters: 49
Members: 32324
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —
