Forum Discussion

Yoshimitsu411's avatar
Yoshimitsu411
Resolver I
4 years ago

TotalYTD Based on Sum is Showing Incorrect Values

Hi All   I have the following measures:   UseRelationship is commented out because I didn't think it was necessary given the Quantities table is connected to the Date table indirectly via other t...
Need Help
amitchandak's avatar
amitchandak
Super User
4 years ago

Yoshimitsu411 , This year and month should come from the calendar table and the calendar should be marked as a date table(option on right click)

 

 

Why Time Intelligence Fails - Power bi 5 Savior Steps for TI: https://youtu.be/OBf0rjpp5Hw

Yoshimitsu411's avatar
Yoshimitsu411
Resolver I
4 years ago

Thanks amitchandak 

 

Calendar table is already marked as a Date table. I cannot create an active relationship to it from my table due to other tables being present (circular dependency).

 

I think because there is no active relationship because my fact table and the Calendar table it is picking up values for other months. I need to now how to only show values for dates that are valid in the fact table and Calendar table.

 

Thanks.