Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi,
I have a table called 'Case' in my datamodel that contains 4,392 records that were created YTD so far (after 31st Mar)
Why does the measure below compute a figure that is more than double (9,562)?
YTD New Area = CALCULATE(TOTALYTD(COUNT('Cases'[Into Area Date]),'Date'[Date],"31/03"))
FYI, the Into Area Date was created in Power Query and is formatted as a Date
Date [Date] = CALENDAR(MINX('Cases','Cases'[tpo_legacycasecreationdate]),TODAY()+[FY Days Remaining])
I can't see why this is happening, can anyone help?
Thanks,
Solved! Go to Solution.
Thanks, but i think i've worked it out, the Into Area Date was introduced to my table recently but it has no relationship with my date table. I just connected the 2 together and now the measure works but otheres were reliant on the other relationship are broken.
Looks like the Into Area Date needs its own table
Maybe try DISTINCTCOUNT instead of COUNT if you need distinct values?
Proud to be a Super User!
Paul on Linkedin.
Thanks, but i think i've worked it out, the Into Area Date was introduced to my table recently but it has no relationship with my date table. I just connected the 2 together and now the measure works but otheres were reliant on the other relationship are broken.
Looks like the Into Area Date needs its own table
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
126 | |
78 | |
76 | |
59 | |
51 |
User | Count |
---|---|
164 | |
86 | |
68 | |
68 | |
58 |