Filter column

[Anonymous]

Hi, I am trying to create a filtered column that will filter all the dates into it. 

The '#' represents responded and '20/01/2021' represents resolved. I want to have two columns to put on dashboard next to each other with their counts.  Please see below.  

Thank you very much, apprecite the help. 

[Anonymous]

Hi @Anonymous 

USE

Measure_count# = CALCULATE(COUNT('table',[resolved opn date]),'table',[resolved opn date] = "#")

Resolved = Measure_count# - count('table',[resolved opn date])

[amitchandak · Accepted solution]

@Anonymous , Create two new columns like and use that

if([resolved on date] ="#", blank(),[resolved on date] )

if([resolved on date] <>"#", blank(),[resolved on date] )

[Anonymous]

Thank you very much!