Count number of rows where filter is 1

[Anonymous]

Hello All,

Could you please help to calculate number of rows where filter is 1? I've put this formula but there are wrong calculation:

Count lines undeliv = CALCULATE(COUNTROWS(CDP_data);FILTER('CDP_data';'CDP_data'[Negative))

Many thanks for your help.

[AlB]

Hi @Anonymous 

How do you tell it's not delivered? CAn you show a sample of your table?Try something like this  

Count lines undeliv =
CALCULATE (
    COUNTROWS ( CDP_data );
    FILTER ( 'CDP_data'; 'CDP_data'[Undelivered] = 1 )
)

[Anonymous]

Hi @AlB not delivered i've counted like that:  Negative = if(CDP_data[Undelivered]<0;1;0)

[AlB]

Ok, so then this should work, as a measure in a card visual. If it doesn't, please share a sample of your tables or the pbix:

Count lines undeliv =
CALCULATE (
    COUNTROWS ( CDP_data );
    FILTER ( 'CDP_data'; 'CDP_data'[Undelivered] < 0  )
)

[Anonymous]

@AlB It's working but calculcation is wrong.

I have columnt oredered, delivered, undelivered which is calculated: 

Undelivered = if(CDP_data[Delivered qty]<=CDP_data[Ordered qty];CDP_data[Delivered qty]-CDP_data[Ordered qty];0)+0

And after negative:  Negative = if(CDP_data[Undelivered]<0;1;0)

And I need to know hom many negative (1) lines are in total. 

 

[v-frfei-msft]

Hi @Anonymous ,

Create a measure as below.

countrows =  CALCULATE (
    COUNTROWS ( CDP_data );
    FILTER ( 'CDP_data'; 'CDP_data'[Negative] =1  )
)

[Anonymous]

@v-frfei-msft still the same mistake when I have =1, but it counts correctly when i choose =0.