Graph made from two dimensions

[escalas]

Hi everyone,

It's hard to explain what I want to do but I'll try.  I have it done with excel.

 

 My goal is obtain the last (grey) column. The calculus is the sum of the blue columns divided by the first row. And the dimension on the left is 'Closed Date'. 

 The problem is that in SR totals(1st column) when I filter the data the dimension is 'Created Date'. But on the blue columns the dimension is 'Closed Date'.  My final goal is make a graph with a 'Closed Date' dimension.

In excel I do all the filtering with the tools above and then I put the values ​​by hand in the table. The table has a Closed Date dimension so I put the SR total that has Created Date dimension as if it were the Closed Date. So the question is if I can do this 'cheat' with powerbi. 

Then from this table I make the graph below.

 Thanks in advance.

[spuder · Accepted solution]

Hi,

I can't see in your data the complete thing. But have a look at the DAX expression USERELATIONSHIP()

It allows you to handle with e.g. 2 date columns in one table. It is used as a filter argument in the CALCULATE() function.

[escalas]

thanks @spuder !! That's exacly what I needed