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

     

     

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