Forum Discussion

andhiii079845's avatar
andhiii079845
Icon for Solution Sage rankSolution Sage
3 years ago

Your open_dt and close_dt columns are the reason for the current matrix. can you please share exactly how the matrix should look like?

newbie_powerbi's avatar
newbie_powerbi
Icon for Helper II rankHelper II
3 years ago

thanks for helpin me out andhiii079845 

I don't know how it is affecting but

I have attached the link for the sample file 

 

I need to show the table for distinct count of person whose tickets are open

i.e. only 1 row should be considered for a person (if 2 open tickets are there for same person then max open_dt row should be considered) 

I should show only the highlighted rows & my count should be 2

https://drive.google.com/file/d/1G_sfyGqbAyCbxA359lShcC6z06zDWYIA/view?usp=share_link