Forum Discussion
Help with measure
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.
6 Replies
- Zubair_Muhammad
Community Champion
Anonymous
May be Something like this
Measure = COUNTX ( FILTER ( ALLSELECTED ( TableName[ID Product Compania] ), [Cobertura Días] > 60 ), [Cobertura Días] )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?
OmegaImpactful Individual
Try: Countrows (Filter (TableName, Cobertura Días > 60))
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.
