Help with measure

[Anonymous]

Hi community!

I'm needing help with a measure.

I have to make a count of all the rows that in an specific measure have >60 as value.

Let me show you:

The measure "Cob>60" shows 1 when "Cobertura Días" is > 60. The idea, is have a count of all the "Cobertura Días" that are > 60 like shown in the header of the report (482). That number is wrong.

How should I make this measure to make a count of "Cobertura Días" when its > 60?

Thanks in advance.

[Omega]

Try: Countrows (Filter (TableName, Cobertura Días > 60))

[Anonymous]

Hi everyone! Thanks for the help and replies so far.

At this point, the measure looks like this:

Count Cobertura > 60 = 
COUNTROWS(
    FILTER(
        'FctInventarioBSC';
        [Cobertura Prod MPH] > [TargetCalc]
    )
)

This measure works fine in the next context:

But in this next context it does not work as expected:

As you can see, the measure is only counting does that do not have a second "Id Prod Compañía".

What change should I make to the measure to make it work in this cases?

Thanks in advance.

[Anonymous]

@Anonymous,

Could you please share sample data of your table and post the expected result here? You can share the data via Private Message.

Regards,
Lydia

[Zubair_Muhammad]

@Anonymous

May be Something like this

Measure =
COUNTX (
    FILTER ( ALLSELECTED ( TableName[ID Product Compania] ), [Cobertura Días] > 60 ),
    [Cobertura Días]
)

[Anonymous]

Hi @Zubair_Muhammad, thanks for your fast reply.

Unfortunately, that measure did not work for me.

Is there some info that you need to help clarify?

[Anonymous]

@Anonymous,

Would you please share dummy data of your original table and post the expected result here?

Regards,
Lydia