cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Count without a column

Need help please. I have created a measure which calculates efficiency %. I want to count rows with efficiency say less 50%, how can i do it?
I dont want to add a new calculated column for efficiency as file is already 160 mb and dont want to increase the size further. Thank you in advance for help
3 REPLIES 3
Highlighted
Community Support
Community Support

Re: Count without a column

@Srikanth_dodla,

 

You may refer to the following measure.

Measure =
COUNTROWS (
    FILTER ( SUMMARIZE ( Table1, Table1[Column1] ), [efficiency] < 0.5 )
)
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
New Member

Re: Count without a column

I dont want to create a column.... i dont have a column with the efficiency %. It is there as a measure
Highlighted
Community Support
Community Support

Re: Count without a column

@Srikanth_dodla,

 

Just replace it with your measure.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Solution Authors
Top Kudoed Authors