Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hello all,
I have 3 columns in my table.
Search Terms Click Placement
Face Mask 3 Search Page
Head Mask 10 Product Detail Page
When I Add a Date to this Table
Date Search Terms Click Placement
01/28/2021 Face Mask 2 Search Page
01/29/2021 Face Mask 1 Product Detail Page
I want to be able to collect clicks according to the placements I want to do, for example, I want to calculate how many clicks on the word face mask come from the search page and how many product detail pages, and I want to do this without adding a date to my table.
By the way I created Placement column with dax formula.
User | Count |
---|---|
10 | |
9 | |
7 | |
4 | |
4 |