Forum Discussion
Submitted and completed in one matrix
Hi,
guided by this https://community.powerbi.com/t5/Desktop/Received-vs-Closed-against-Year-Month/td-p/123515 link I've tried to make similar matrix.
This is what I got: (I have different titles for table, don't bare that in mind)
Axis = .Done (from formula below)
Value = Ticket
Also a filter for tickets with exact statuses (which is probably not a point).
But matrix shows bit different values:
These .Closed and .Received are new formulas based on example in the same link you posted (https://community.powerbi.com/t5/Desktop/Received-vs-Closed-against-Year-Month/td-p/123515)
.Closed = CALCULATE(COUNTA('Model'[Completed]), USERELATIONSHIP('Model'[Completed], MasterCalendar[EveryDate]))
&
.Received = COUNTA('Model'[Submitted]) ---- this one works as expected and shows same numbers
For .Closed I've also tried COUNTA('Model'[.Done]), but result is the same as with Completed. Different from first visual.
Long story short, Matrix shows completed by the rule of submitted.
E.g., completed in August will be those, that were submitted in August. So these 2 columns are still related, though I added calculations as per article you provided
.Closed = CALCULATE(COUNTA('Model'[Completed]), USERELATIONSHIP('Model'[Completed], MasterCalendar[EveryDate]))
&
.Received = COUNTA('Model'[Submitted]) ---- this one works as expected and shows same numbers
Please assist.
Anonymouscould you please help further?
Up. Can anyone point me on what I'm missing? Combining two columns together results in Submitted priority.