Forum Discussion

rgreener's avatar
rgreener
Frequent Visitor
6 years ago

MTD, QTD, YTD Variance card visuals, MTD is accurate QTD and YTD are not HELP

Hello-   I have been emersed in Power Bi for a few months now and an certainly still new at this. I have a table visual where each column is represented by a measure. I am working with multiple tab...
rgreener's avatar
rgreener
Frequent Visitor
6 years ago

Hello and thank you for your response. I miss spoke. The relationships are all one to one, not one to many. I will change the filter direction to single based on your input.  I believe that Power BI automatically selected that filter direction and relationship for me, I will adjust this. I am sure it is possble that the model has an issue as you pointed out.  I will test those measures again and if there is an issue I will rebuild. 

 

Much thanks.

 

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Wait... How is it possible that the relationships are one to one? No sane model would be built this way.

A correct model is a star schema where dimensions are connected to the fact tables in a one-to-many manner... You must have made a mistake.

Best
D
  • rgreener's avatar
    rgreener
    Frequent Visitor
    6 years ago

    Hello-

     

    Thank you for your reply again and patience here. I understand star and snowflake schema, certianly not as much as you do I imagine. I have one main fact table with four dimention tables. All relationships are many to one. I just recently brought another dimention in and it looks like the relationship is 1:1 which as you stated would be an issue. I am going to change that relationship and see if I have any better luck. Thanks again for sharing your knowledge.

     

    Ryan

  • rgreener's avatar
    rgreener
    Frequent Visitor
    6 years ago

    I will be doing much reading on this to get smarter. THank you for pointing this out.