cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Super User
Super User

Re: Combining Data from multiple tables on a shared timeline

Hi @asaft,

 

I believe is that what is happening is that you are getting the total values of the Closed cases, but not sure can you possible share some sample data?

 

Regards,

Mfelix



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




asaft Regular Visitor
Regular Visitor

Re: Combining Data from multiple tables on a shared timeline

Hi @MFelix,

 

What if instead of this calculation, I will pull into the date table, another column with the number of cases opened on each date. It would serve the same purpose. Just that not sure this is logically possible. The Open date and the close date are on the same table. 

 

What would be the best way to privately share with you a sample data?

 

Thanks for your persistence (-:

 

Asaf

Highlighted
Super User
Super User

Re: Combining Data from multiple tables on a shared timeline

Hi @asaft,

 

Just created a model with two table with your data Backlog and Closed cases mades changes to distinct count on your measure and got the result below.

 

Count accumulate = 
VAR previous =
MIN ('Date Table'[Date]) - 1
VAR Ranking =
RANKX (
ALLSELECTED ('Date Table'[Date]);
CALCULATE (DISTINCTCOUNT(Backlog[Case Number]));
;
ASC
) //Calculates the ranking based on the period number in order to work with different period slicers
RETURN
DISTINCTCOUNT(Backlog[Case Number])
- CALCULATE (
DISTINCTCOUNT(Backlog[Case Number]);
FILTER (ALL(Backlog);Backlog[Snapshot Created Date] = Previous )
) //Calculation of variation to previous period
+ CALCULATE (
DISTINCTCOUNT('Closed Cases'[Case Number]);
FILTER(ALL('Closed Cases'); 'Closed Cases'[Date/Time Closed] = MIN('Date Table'[Date]))
)

Backlog.png

 

Believe everything is as needed. Please check it and tell me.

 

Regards,

MFelix



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




View solution in original post

asaft Regular Visitor
Regular Visitor

Re: Combining Data from multiple tables on a shared timeline

Thanks so much @MFelix!

 

This has been really helpful!

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 241 members 2,540 guests
Please welcome our newest community members: