Forum Discussion

Srikanth_dodla's avatar
Srikanth_dodla
New Member
8 years ago

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

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Icon for Community Support rankCommunity Support
    8 years ago

    Srikanth_dodla,

     

    You may refer to the following measure.

    Measure =
COUNTROWS (
    FILTER ( SUMMARIZE ( Table1, Table1[Column1] ), [efficiency] < 0.5 )
)