Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Reply
Anonymous
Not applicable

apply measure on multiple column

‎10-17-2019 01:57 AM

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

Count.PNG
 
 

 

Labels:
Message 1 of 3
342 Views
0
2 REPLIES 2
v-diye-msft
Community Support
Community Support

‎10-20-2019 06:47 PM

Hi @Anonymous 

 

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

CF10111 = CALCULATE (COUNT (GetIssues [customfield_10111]), Filter(GetIssues,[customfield_10111] <> BLANK ())
Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.
Message 2 of 3
280 Views
0
Anonymous
Not applicable
In response to v-diye-msft

‎10-22-2019 12:35 AM

 

Hello,

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

Message 3 of 3
268 Views
0

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

View All