The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
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
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
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.
User | Count |
---|---|
74 | |
70 | |
39 | |
30 | |
28 |
User | Count |
---|---|
104 | |
95 | |
51 | |
48 | |
46 |