apply measure on multiple column

[Anonymous]

Hello,

I want to apply a measure on 103 columns that have a name beginning with "customfield_xxx".

Here is the measure:

CF10111 = CALCULATE (COUNT (GetIssues [customfield_10111]); GetIssues [customfield_10111] <> BLANK ())

cordially

[v-diye-msft]

Hi @Anonymous 

Do you mean you'd like to get below measure?

CF10111 = CALCULATE (COUNT (GetIssues [customfield_10111]), Filter(GetIssues,[customfield_10111] <> BLANK ())

[Anonymous]

Hello,

Yes I wish a new table with this measure for my 103 columns