Forum Discussion

augustindelaf's avatar
augustindelaf
Icon for Impactful Individual rankImpactful Individual
9 years ago
Solved

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

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's avatar
    Anonymous
    9 years ago

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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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's avatar
      augustindelaf
      Icon for Impactful Individual rankImpactful Individual

      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