Power BI Matrix how show count of Table Column date where it matches todays date()

[Anonymous]

Hi using Power BI Card Vizualization i would like to display the count of a date which matches todays date.

Example:
Table 1
Name    Date
Kerry     12/12/2019
Dave     12/12/2019
Steve    10/12/2019
Joe        11/12/2019

So for example if today date is 12/12/2019, i would like the Card vizualization to count the number of rows which match todays date only 'Today ()'. So it will show the count as  "2" as that is todays date.

[parry2k · Accepted solution]

@Anonymous can you share sample pbix file?

[parry2k]

@Anonymous use this measure

Count Rows = CALCULATE ( COUNTROWS ( Table ), Table[Date] = TODAY() )

[Anonymous]

Hi Parry,

I have followed what you have advised. However the Power Bi Card is showing "Blank" when using the new Count Rows Column.
I have checked my data and i have got data in the column which is  datetime'12/12/2019/ 12:05:00" and also tried it with another column which is just date '12/12/2019/'. However it is still showing results as blank when using the card vizualization.

[v-diye-msft · Accepted solution]

Hi @Anonymous 

The post from @parry2k should work, the blank could probably today is 13th not 12th, when I change the date from 12/12 to 12/13, the measure works:

[parry2k · Accepted solution]

@Anonymous can you share sample pbix file?