Forum Discussion

GhadaMehrez's avatar
GhadaMehrez
Helper III
4 years ago

Measure Filter

Currently, I have a dashboard, which contains the below fields:   1- Estimated Total Cost (%) >>>> this is custom measure 2- Actuals Cost (%)>>>> this is custom measure 1- Estimated Total Cost ($...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi GhadaMehrez ,

 

I suggest you to add a duraction flag column in 'Product' table.

Duration Flag =
SWITCH (
    TRUE (),
    [No.of months] <= 12, "Short Term",
    [No.of months] <= 24, "Mid Term",
    "Long Term"
)

Then you can filter your measure by the slicer which is built based on this calcualted column.

 

Best Regards,

Rico Zhou

 

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

 

GhadaMehrez's avatar
GhadaMehrez
Helper III
4 years ago

thanks a lot for your help but I don't have permission to add column so I added {duration} measure as you suggested but I still cannot filter card visuals by Duration measure :

 

I have another idea maybe I need to update this measure by adding filter by duration, could you help me in this:

 

 

% ETC V3 =
DIVIDE(
[ETC This Year],
CALCULATE(
Sumx(FILTER(Projects, [fls_actualenddate], [fls_actualstartdate], [Duration Flag] Short Term),
ALL('Projects'[fls_StrategyThemeName]),
)
)