Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

apply measure on multiple column

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

 
 

 

Need Help

2 Replies

  • v-diye-msft's avatar
    v-diye-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous 

     

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

    CF10111 = CALCULATE (COUNT (GetIssues [customfield_10111]), Filter(GetIssues,[customfield_10111] <> BLANK ())
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

       

      Hello,

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