cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Srikanth_dodla Frequent Visitor
Frequent Visitor

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
Community Support Team
Community Support Team

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.
Srikanth_dodla Frequent Visitor
Frequent Visitor

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 Team
Community Support Team

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.