Forum Discussion

sunilvs24's avatar
sunilvs24
Frequent Visitor
8 years ago

Calculating Sum

Hi All, Any one please help me to understand, what might be wrong here. It is not showing up any error, but when i pull the measure on a card, value does not show up. M_CurrentWeek is a measure - Returning the value of the current week from a column in a table While performing a sum, i need it to be < = CurrentWeek, which is where i am not able to get through. On top of this i have 2 more conditions, which i will insert. Help me insert the measure value, which should be <= Below is the formula: M_Actuals_CurrentWeek = CALCULATE(sum(Waterfall_RS[value]),FILTER(Waterfall_RS,Waterfall_RS[Period_Week13]<=[M_CurrentWeek])) Thanks !!