Count if DATEDIFF > 12

[Oomsen]

Hello.

I want to count how many items in our inventory aren't used for more then 12 months. 

I created a LASTDATE and a DATEDIFF measure to see which items need to be count.

The result is:

Item no    LASTDATE        DATEDIFF

10.009      10-07-2017      21

10.011       1-11-2017       17

10.035       1-11-2017       17

The result of the new measure i'm looking for should be 3.

[Zubair_Muhammad]

@Oomsen 

Try this MEASURE

Measure=
COUNTROWS ( FILTER ( VALUES ( tableName[Itemno] ), [DATEDIFF] > 12 ) )

[Oomsen]

It looks like your measure is working. But, when i place the measure in a KPI-visual it doens't show the total quantity. Any idea?

[Zubair_Muhammad]

Hi @Oomsen 

Do you mean it works in Card visual but not in KPI visual?

[Oomsen]

Yes

[Zubair_Muhammad]

@Oomsen 

try this revision

Measure =
COUNTROWS ( FILTER ( ALLSELECTED ( tableName[Itemno] ), [DATEDIFF] > 12 ) )

[Oomsen]

Still same result.