Need help with HASONEFILTER since the original measure isnt working

[analyst312]

Working on a measure that calculated the month/month difference. I was able to pull one together that works but now the totals dont total correctly. Ive ran into this problem before but can never get the HASONEFILTER correct.

Here is the first measure:

Mo/Mo Diff =IF(CALCULATE(
    [Sum of Census],
    PARALLELPERIOD(
        'Calendar'[Dates],
        -1,
        MONTH)
) = BLANK(),

BLANK(),

[Sum of Census]-CALCULATE(
    [Sum of Census],
    PARALLELPERIOD(
        'Calendar'[Dates],
        -1,
        MONTH)
))

Second measure with the HASONEFILTER

Mo/Mo Diff FIX =IF(HASONEFILTER('Calendar'[Month]),
[Mo/Mo Diff],
SUMX(VALUES('Calendar'[Month]),
[Mo/Mo Diff]))

[v-luwang-msft]

Hi @analyst312 ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

[amitchandak]

@analyst312 , what are trying to achieve here? Please provide some details

refer https://p3adaptive.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/

https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/