Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
User | Count |
---|---|
101 | |
90 | |
78 | |
70 | |
69 |
User | Count |
---|---|
110 | |
96 | |
95 | |
74 | |
71 |