Show results if filter is blank

[Roym]

I have the following code that shows the number of issues were the control name is not blank. This works correctly. But now I need to have it the other way around, so it should count if there is not a link, so the Control name is blank. I thought I could do this by changing the 'not(isblank'  to 'isblank'.  But then I get no results. Is there something I do wrong in this code?

Working, not blank calculation:

Measure = CALCULATE ( DISTINCTCOUNT(Table_Issues[Name]),

filter (Table_Controls , not(isblank(Table_Controls[Control Name] )) ) )

Not working isblank calculation:

Measure = CALCULATE ( DISTINCTCOUNT(Table_Issues[Name]),

filter (Table_Controls , isblank(Table_Controls[Control Name]) ) )

[amitchandak · Accepted solution]

@Roym , It should work

Try like

M1 =DISTINCTCOUNT(Table_Issues[Name])

M2= sumx(filter( values(Table_Controls[Control Name]), isblank([M1])),[M1])

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Roym]

I got it working this way, thanks!!