Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
42 | |
23 | |
21 | |
15 | |
15 |
User | Count |
---|---|
46 | |
31 | |
30 | |
18 | |
18 |