Count no of rows in a month with no transactions in table

[Varun511]

HI,

have a  date table  and fact table ,fact table  granularity is Transaction date have joined date table with transaction date with one to Many relationship 

need to Count number process in Fact table and have a date slicer in report for suppose if i select may 1st till May 31st number of process should get 25 but i got 19  because other 6 process dont have any transactions yet but need to show those as well in report

 tried using Calculate(count(process),ALL(Date) but this is completing eliminating date context but want to have date context but need to show all the process even though there is no transactions in fact table any help would be highly appreciated

[v-jingzhang · Accepted solution]

Hi @Varun511 

For the "other 6 process dont have any transactions", does it mean that these 6 processes don't have transaction dates? If so, you can try this measure

Process Count = COUNT ( 'Table'[process] ) + CALCULATE ( COUNTBLANK ( 'Table'[Transaction date] ), ALL ( 'Table' ) )

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.