Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
ArchStanton
Post Prodigy
Post Prodigy

Measure is computing wrong value

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,

1 ACCEPTED 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

View solution in original post

2 REPLIES 2
PaulDBrown
Community Champion
Community Champion

Maybe try DISTINCTCOUNT instead of COUNT if you need distinct values?





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

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

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.