Dax Measure IF > sum/Average & format$/format%

[augustindelaf]

Hi All, 

simple question for you, I'm sure.

I have a "IF" measure that works fine (moduling sum or average for a same field), I just want to add some "Format" arguments  in it, can you help me please?

Here is the measure that works : 

VarKPI2MonthlyActual =
IF('DATA(Update KPIs)'[SelectedValue] ="WS 3.5";
AVERAGE('DATA(Update KPIs)'[KPI 2 Monthly Actual]);
SUM('DATA(Update KPIs)'[KPI 2 Monthly Actual]))

Here is the measure that I want : 

VarKPI2MonthlyActual =
IF('DATA(Update KPIs)'[SelectedValue] ="WS 3.5";
AVERAGE('DATA(Update KPIs)'[KPI 2 Monthly Actual]);  FORMAT ('DATA(Update KPIs)'[KPI 2 Monthly Actual]);"Currency";
SUM('DATA(Update KPIs)'[KPI 2 Monthly Actual]))         FORMAT ('DATA(Update KPIs)'[KPI 2 Monthly Actual]);"Percent"

it doesn't work, can you please help me ?

thanks !

[Anonymous · Accepted solution]

VarKPI2MonthlyActual =
IF (
    'DATA(Update KPIs)'[SelectedValue] = "WS 3.5";
    FORMAT ( AVERAGE ( 'DATA(Update KPIs)'[KPI 2 Monthly Actual] ); "Currency" );
    FORMAT ( SUM ( 'DATA(Update KPIs)'[KPI 2 Monthly Actual] ); "Percent" )
)

[augustindelaf]

@Anonymous

perfect !

so angry that syntax is not easy for me, but it should be.

I tried to encapsulate but it didn't work... 😞 now it is fine !

thank you