How to find intersecting points in a set of periods

[Yulia]

Good afternoon. Tell me how to solve this problem in Power BI, or at least the direction of thoughts. There is a large database that will continue to be supplemented, it has 4 or more periods (Feb.19, may.19, Aug.19, Nov. 19, etc.) with point codes, by city, brands, SKU, prices, advertising materials, etc. you need to display intersecting points when selecting (in the slicer) periods. For example, show the number of points for the brand "XX" in the city of "Moscow" that were in the selected periods of February.19 and Nov.19. or the number of intersecting points in the period may-August-November. The client can choose any combination of periods. You can translate periods into dates, but I do not understand what this can give. Tell me how to solve this problem? Perhaps someone had similar cases. Any help, I would be grateful.

[Icey]

Hi @Yulia ,

Is this problem solved?

If it is solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If not, please let me know.

Best Regards
Icey

[amitchandak]

What to you meant  by "number of intersecting points"

Two you won't compare two ranges and can have any months?

[Yulia]

Tell me how to solve this problem. You need a measure (or perhaps a calculated column) that counts the number of intersecting "point codes" depending on the selected periods. Select periods using the slicer. For example, you selected 3 periods "Aug-Dec-may", count the number of "point codes" that were in all three periods. Test example in the attachment

Intersecting points 

[Icey]

Hi @Yulia ,

Is "46" the count value you want?

If it is, just create a measure like so:

Count = COUNTROWS(Tabl1)

And then, create a Card visual.

If not, please show me more details to help me know what you want.

Best Regards,
Icey

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