Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
98 | |
75 | |
63 | |
62 |
User | Count |
---|---|
135 | |
105 | |
104 | |
80 | |
65 |