Forum Discussion

GhadaMehrez's avatar
GhadaMehrez
Icon for Helper III rankHelper III
4 years ago

add filter to measure formula

Please I need support here I have measure calculating percentage of {Total estimated cost} per each strategy category    but now I need to add filter to the measure to give me the percentage also b...
Need Help
GhadaMehrez's avatar
GhadaMehrez
Icon for Helper III rankHelper III
4 years ago

v-chenwuz-msft  Thanks for your support,

 

But the output of the measure is wrong it gives me 132% as the screen below:

 

I tried to update the measure to rely on another measure {Duration Flag}

but it gives error could you support :

 

% AB = DIVIDE ( [ETC This Year], CALCULATE ( [ETC This Year], FILTER ( ALLSELECTED ( Projects ), [Duration Flag] Short Term ) ) )

 

v-chenwuz-msft's avatar
v-chenwuz-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi GhadaMehrez ,

 

This:

%AB =
VAR _all =
    CALCULATE (
        [ETC This Year],
        FILTER ( ALLSELECTED ( Projects ), [no.month] <= 12 )
    )
VAR _s =
    SUMMARIZE (
        Projects,
        [fls_strategythemename],
        [pum_name],
        "etc", [etc this year],
        "ab", DIVIDE ( [etc this year], _all )
    )
RETURN
    SUMX ( _s, [ab] )

 

Best Regards

Community Support Team _ chenwu zhu

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.