Forum Discussion

jct999's avatar
jct999
Icon for Advocate II rankAdvocate II
4 years ago

Incorrect result with nested measure

Hi All   I have 2 measures :  IMPORTER_MARKET_ACTUAL IMPORTER_MARKET_ACTUAL_CY_MTD that references IMPORTER_MARKET_ACTUAL. The purpose of this 2nd measure is to restrict the time scope of the fi...
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi jct999 ,

Please modify the IMPORTER_MARKET_ACTUAL_CY_MTD.

 

IMPORTER_MARKET_ACTUAL_CY_MTD :=
VAR cy = 2022
VAR cm = 4
VAR r =
    CALCULATE (
        [IMPORTER_MARKET_ACTUAL],
        FILTER ( ALL ( DATASET ), 'DATASET'[YEAR] = cy && 'DATASET'[MONTH] <= cm )
    )
RETURN
    r

 

 

If I have misunderstood your meaning, please provide some sample data without privacy information and desired output.

 

Best Regards

Community Support Team _ Polly

 

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