Forum Discussion

siminaserban's avatar
siminaserban
New Member
8 years ago
Solved

Cumulative count

Guys,   Need your help. I am lost :).   So, basically, we are trying to calculate a cumulative count of days per week. What is strange is that in one of the reports, in another file with other da...
Need Help
  • siminaserban's avatar
    siminaserban
    8 years ago

    Hi All,

     

    In sanitizing the data and recreating the dat amodel I have notice the issue in the data model.

     

    One of the joins had the cross filter direction set to both. What I found strange is that this affected also the cumulative counts from other tables where there was not a direct relationship to this table.

     

    Thanks for all the support! This has been solved

     

     

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi siminaserban,

 

Since it works in one file, there could be something wrong other than the measures.

1. Where are the columns from? Are they from similar position of the mode?

2. Are the relationships different?

Can you share the file with us? Please mask the private data first.

 

Best Regards,

Dale

siminaserban's avatar
siminaserban
New Member
8 years ago

Dale,

 

1) The data sources are Excel files at this point. They will be sharepoint lists in the end. The data models in both pbix are created in the same way.

2) The relationships are the same.

 

I will sanitize the data and uploaded here. I do not get it where is the issue.

 

Thanks,

Simina

  • siminaserban's avatar
    siminaserban
    New Member
    8 years ago

    Hi All,

     

    In sanitizing the data and recreating the dat amodel I have notice the issue in the data model.

     

    One of the joins had the cross filter direction set to both. What I found strange is that this affected also the cumulative counts from other tables where there was not a direct relationship to this table.

     

    Thanks for all the support! This has been solved