Count specific values

[powertechbi]

Good morning

I need to create a measure that gives me the number of products I have that have a specific value in the Saldo Fim Mês column

The Product ID column is obtained from the products table. The Saldo Fim Mês column is obtained through the calculation indicated in the measurement shown in the image.

For example: In the image I have 2 products that have values ​​equal to or greater than 6. For this example, the measurement I need to create would have to bring me 2 as a result.

Could anyone help me?

Thank you in advance.

[muhammad_786_1 · Accepted solution]

Hi @powertechbi 

I hope you can get your desired output using this measure. This measure will count the number of products where the Saldo Fim Mês is 6 or greater.

Count Products Measure =

CALCULATE(

    COUNTROWS('Products'),

    FILTER(

        'Products',

        [Saldo Fim Mês] >= 6

    )

)

Best Regards,
Muhammad Yousaf

If this post helps, then please consider "Accept it as the solution" to help the other members find it more quickly.

LinkedIn

[powertechbi]

Thanks a lot !!!!😎

[selimovd]

Hey @powertechbi ,

where are the 6 coming from?

I see you calculate the Sum of Qtde where the date is larger than the MAX date + Esoque Actual.

No idea what all of that means. Maybe give a sample file and a little bit more explanation, otherwise it's difficult to help you.

Best regards

Denis

[powertechbi]

@selimovd 

I need to create a measure that gives me the number of products I have that have a specific value in the Saldo Fim Mês column

The Product ID column is obtained from the products table. The Saldo Fim Mês column is obtained through the calculation indicated in the measurement shown in the image.

For example: In the image I have 2 products that have values ​​equal to or greater than 6. For this example, the measurement I need to create would have to bring me 2 as a result.