cancel
Showing results for
Did you mean:
Post Partisan

## Count Items which occurs again

Hi,
I need to create 2 measures.

• The first one should count how many items occur again today.
• The second one should tell how many times this particular item occur in the past.

Sample data below:

 Date Item ID 02.10.2020 (today) A 02.10.2020 B 02.10.2020 C 01.10.2020 B 28.09.2020 C 27.09.2020 C
1 ACCEPTED SOLUTION
Community Support

Hello @pawelj795 ,

``````Measure 1 =
var t1_=
CALCULATETABLE (
VALUES ( 'Table'[Item ID] ),
FILTER (
ALL ( 'Table'[Date] ),
'Table'[Date] < MAX('Table'[Date]) )
)
var t2_=
CALCULATETABLE (
VALUES ( 'Table'[Item ID] ),
FILTER (
ALL ( 'Table'[Date] ),
'Table'[Date] = MAX('Table'[Date]) )
)
return
COUNTROWS(INTERSECT(t1_,t2_))``````
``Measure 2 = CALCULATE(COUNT('Table'[Date]),ALLEXCEPT('Table','Table'[Item ID]))``
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 REPLIES 4
Community Support

Hello @pawelj795 ,

``````Measure 1 =
var t1_=
CALCULATETABLE (
VALUES ( 'Table'[Item ID] ),
FILTER (
ALL ( 'Table'[Date] ),
'Table'[Date] < MAX('Table'[Date]) )
)
var t2_=
CALCULATETABLE (
VALUES ( 'Table'[Item ID] ),
FILTER (
ALL ( 'Table'[Date] ),
'Table'[Date] = MAX('Table'[Date]) )
)
return
COUNTROWS(INTERSECT(t1_,t2_))``````
``Measure 2 = CALCULATE(COUNT('Table'[Date]),ALLEXCEPT('Table','Table'[Item ID]))``
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super User IV

The information you have provided is not making the problem clear to me. Can you please explain with an example.

These can be two measures what I can get from a high level

calculate(distinctcount(Table[Item ID]), Table[Date] =today())

calculate(distinctcount(Table[Item ID]), Table[Date] < today())

Proud to be a Super User!

Post Partisan

Hi @amitchandak

Alluding to my above sample, I explain what I meant.

• First measure:
The result should be 2, because only item "B" and item "C" appear again today.
• Second measure:
For the Item "B" the result should be 2. (also include today) - It appeared on 02.10.2020 and 01.10.2020
For the Item "C" the result should be 3. - It appeared on 02.10.2020, 28.09.2020, and 27.09.2020.

If it's still not clear to you, please tell me which part is confusing.
Post Partisan
.

Announcements