Flag a cell with 1 if not blank per month and blank if blank and calculate the total number of flags

[Anonymous]

Basically I have a measure that is the Net Invoice Amount. What I'm trying to do is display flags (1) is the measure (Net Invoice Amt) is not blank in that month within that row.

See the image:

I have tried the measure formula: RowNum = CALCULATE(COUNTX('Store Invoice','Store Invoice'[Store ID]), FILTER('Secondary Sales Invoices','Secondary Sales Invoices'[Net Secondary Amt - Invoiced])) but it displays the wrong result. There is no way the values are the same.

[jdbuchanan71 · Accepted solution]

Hello @Anonymous 

Give this a try.  It assumes that the measure is called [Net Invoice Amt].

COUNTX ( VALUES ( 'Store Invoice'[Store ID] ), [Net Invoice Amt] )

[Anonymous]

Woah!! That actually worked! Thank you so much.