Hello all,
I have been struggling to get my measure below to work correctly, could you provide assistance? This measure is to calculate the cummulative total by PO_Fscl_Perd_Nb and by ID, ignoring the filters on the Doc_Dt column but allow filtering from other columns within a table as well as another table called Project that has one to many relationship to the SAP table on the ID columns, ( the table has these columns ID, Name, SubCategory, Category). The current measure doesnt ignore filters coming from the Doc_Dt column. I have been trying to change the ALLSELECTED to ALL but still didnt work, would really appreciate expert insights.
Cummulative YTD Actual =
VAR currentCloseMonth =
MAX ( 'Closed Calendar'[Closed Actual Month] )
RETURN
CALCULATE (
SUM ( SAP[PO_Std_Amt] ),
FILTER (
ALLSELECTED ( SAP ),
SAP[ID] <= MAX ( SAP[ID] )
&& SAP[PO_Fscl_Perd_Nb] <= MAX ( SAP[PO_Fscl_Perd_Nb] )
),
ALL ( SAP[Doc_Dt] )
)
