Table showing incorrect total

[Amitkr174]

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.

[Amitkr174]

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.

---

[Anonymous]

can you upload some data?