Forum Discussion

Charu's avatar
Charu
Icon for Post Patron rankPost Patron
8 years ago

How to use both Avg and sum function in DAX

Hi Everyone,   I have 4columns like below Col1 : Col2 : Col3 : Col4 0         0       1         0 I want to first sum these 4 columns and then need to get Average. Please help me how to create ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Charu,

Do you connect to Oracle in Power BI Desktop? Could you please post a screenshot about how you apply PietroFarias's DAX in your table?

Regards,
Lydia

Charu's avatar
Charu
Icon for Post Patron rankPost Patron
8 years ago

Hi Anonymous

 

Yeah, I'm connecting oracle database direct query mode and in the advanced options passing SQL statements(many tables join) and getting data.

Sample is 

ID | Code | Tgt 1 | Tgt2 | Tgt3 | Tgt4

1  | 001    | 0       |  0     | 0      | 0

2  | 003    | 1       |  0     | 0      | 0

 

I need to take sum (tgt1,tgt2,tgt3,tgt4) and then the Avg of the sum(tgt1,tgt2,tgt3,tgt4)

I have created measure as suggest by PietroFarias

Measure:= AVERAGEX(Tablename;[Tgt1]+[Tgt2]+[Tgt3]+[Tgt4])