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
Charu's avatar
Charu
Icon for Post Patron rankPost Patron
8 years ago

HI PietroFarias

I tried the measure but I'm getting following error

Error Message:
ORA-00904: "t1"."QTR2_TARGET": invalid identifier. The exception was raised by the IDbCommand interface.

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])