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

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


Regards

Miguel Félix


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

Proud to be a Super User!

Check out my blog:

Power BI em Português





Highlighted
Helper III
Helper III

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 III
Super User III

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


Regards

Miguel Félix


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

Proud to be a Super User!

Check out my blog:

Power BI em Português





View solution in original post

Highlighted
Helper III
Helper III

Re: Combining Data from multiple tables on a shared timeline

Thanks so much @MFelix!

 

This has been really helpful!

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors