FYTD measure not correct

[Anonymous]

Hi Community,

I am stuck with something probably quite simple, need your help to figure this out.  The FYTD totals are wrong for some months below: FY is from July to June

PBI link is : https://1drv.ms/u/s!Ag919_pO_UKrgQV6IfRLFFZluD2V?e=xnh2y2

TIA,

Meena

[mahoneypat · Accepted solution]

Thanks for providing the pbix file.  Your measure is doing a distinctcount, so you must have had duplicates in those months that didn't get counted.  Please try this expression to get your desired result.

FYTD =
CALCULATE (
    SUMX (
        SUMMARIZE ( Datedim, Datedim[Year], Datedim[Month] ),
        CALCULATE ( DISTINCTCOUNT ( Data[p_id] ) )
    ),
    DATESYTD ( Datedim[Date], "30/6" )
)

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

[Anonymous]

Thanks a lot @mahoneypat for your solution & explaination! Much appreciated😊