Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
When I am putting a measure (Named -'Actual Revenue') in a table, the total is not reflecting correctly.
I am attaching the Power Bi total screenshot and Excel total screenshot (Actual revenue). The total should reflect 487K in power bi table.
DAX to calculate 'Actual Revenue' = Actual amt/pacing%
I tried different measures as mentioned below:-
'Revenue (Using Sumx)' =
Could someone please assist on this?
@Amitkr174 wrote:Hi,
When I am putting a measure (Named -'Actual Revenue') in a table, the total is not reflecting correctly.
I am attaching the Power Bi total screenshot and Excel total screenshot (Actual revenue). The total should reflect 487K in power bi table.
DAX to calculate 'Actual Revenue' = Actual amt/pacing%
I tried different measures as mentioned below:-
'Revenue (Using Sumx)' =
a.) SUMX (SUMMARIZE ( Budget, Project[Project Name], Budget[Budget Name], Budget[Budget ID], Project[ACS Industry]),DIVIDE (Actual amt,pacing% ) )b.) SUMX(VALUES(Budget),DIVIDE (Actual amt, pacing% ) )The total is coming at 600K by using a) & b) measures while the correct amount which should reflect is 487K.
can you upload some data?
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
24 | |
9 | |
7 | |
6 | |
6 |
User | Count |
---|---|
29 | |
11 | |
11 | |
10 | |
6 |