Forum Discussion
Submitted and completed in one matrix
Hi, I have a table of tickets with submited, completed, closed, etc. dates and other various info. I do understand how to separate them in two different visuals (like below): So this wi...
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.