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 p...
Need Help
Tips and Tricks
  • 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" )
    )

Anonymous's avatar
Anonymous
Not applicable
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" )
)

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

    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