count/distinct coun of current month, if there is no Month/value selected in filter visual

[Amardeep100115]

Hi 

I wish to get a count/distinctcount of currunt month of "PIN Code" if there is no Month/value selected in filter visual.

I have tried below formula in my base report but its not showing me correct value,

Please help

Pre soj = IF(HASONEVALUE(Query1[Mnth_Yr]),[HC],COUNTAX(FILTER(Query1,Query1[File Date]="August_2019"),[HC]))

https://1drv.ms/u/s!Ai3rGPgy20kLwUsY5cG6RUA71nDt?e=lFOkYL

[v-frfei-msft · Accepted solution]

Hi @Amardeep100115 ,

Update your measure as below.

Measure 2 = 
var currentmonth = FORMAT(TODAY(),"mmmyyyy")
return
IF (
    ISFILTERED ( Sheet4[month] ),
    DISTINCTCOUNT ( Sheet4[Pin No] ),
    CALCULATE (
        DISTINCTCOUNT ( Sheet4[Pin No] ),
        FILTER ( Sheet4, FORMAT ( 'Sheet4'[As of date], "mmmyyyy" ) = "Jul2019" )
    )
)