Forum Discussion

CharllesCorrea's avatar
CharllesCorrea
New Member
3 years ago

How to split Closed and Opened tickets without duplicate tables?

Hi everyone! I have a table with the following columns: Ticket ID Description Opened at Closed at The ticket will be marked as "Open" if the Closed at column is blank. I need to show the inf...
General Comment
Need Help
Tutorial Requests
RemyO's avatar
RemyO
Icon for Resolver I rankResolver I
3 years ago

Create 2 measures 1 for open 1 for closed calls

 

Something along the lines of

OpenCalls = CALCULATE(COUNT('Table'[ColumnName]),FILTER('Table',ISBLANK('Table'[Closed at])  = TRUE))

ClosedCalls = CALCULATE(COUNT('Table'[ColumnName]),FILTER('Table',ISBLANK('Table'[Closed at])  = FALSE))

 

Dont know if my DAX is correct since i am not an expert and do not have test data

 

Then move the measure in you visual