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

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.

Reply
wuvane
Regular Visitor

Help - YTD equation not giving me the answer I expect and I don't know why

Hi All,

I am very new to Power BI but been very pleased to create something useful quickly. I have used this equation in tables within the same model and it worked fine. For some reason it is now only summarising for one Cluster, I can't see why as I shouldn't have any context filters on the data.

 

I have checked my relationships which are only set up with two tables, a date table 1:many and a Site table 1:many, these are working for all other measures. I have reloaded the data from scratch, checked the data table, and deleted all equations and started again... what am I missing?!

 

wuvane_2-1661426083571.png

 

Thanks in advance, lots of head scratching here!!

 

 

7 REPLIES 7
wuvane
Regular Visitor

Hi, thanks for the response, no change when I remove it and it works in other calcs...

 

It feels very odd like a glitch, is there a way to break/check what's driving it?

Why SUMX and not SUM?

What happens if you use the standard TOTALYTD DAX function?

The Cluster should just be dimensionality on the data, should not affect the calculation, only the context of it.




Did I answer your question? If so, mark my post as a solution. Also consider helping someone else in the forums!

Proud to be a Super User!





No reason for SUMX, still trying to understand the language (week 4!!)

 

I have tried to use the DAX function, not sure if this is right but it then only returns data for a site in the North Cluster, its like the relationships aren't right.

wuvane_0-1661432321663.png

 

Can you show us the relationships?




Did I answer your question? If so, mark my post as a solution. Also consider helping someone else in the forums!

Proud to be a Super User!





Sure, also just looking again and can't be sure if this has changed but both the Quality and HSER metrics are experiencing the same issue now I have checked. I.e. only the North Cluster is bringing back data. These are the only areas I am doing the calculations for YTD so maybe it is a calculation issue.

 

wuvane_0-1661433555240.png

 

Thanks so much for your help with this, I have found it!! 

 

I had a table that I didn't realise had a dual directional relationship and it was filtering back for just the North  in a single site onto the rest. Lesson learnt! 

ToddChitt
Super User
Super User

Can we assume that the "30/04" is the year end? And that your regional settings are such that it is able to interpret that? My regional settings would want that to be "4/30". 

What happens if you take that part out? Does it calculate properly for a year ending on December 31?




Did I answer your question? If so, mark my post as a solution. Also consider helping someone else in the forums!

Proud to be a Super User!





Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.