Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I'm breaking my head on doing, and I cant get nowhere.
I have two tables only unified by relation where I can relate the offers and person and country:
And I want to do a distinct count of how many offers where above the target value, and then group the results by country:
I've tried the following measure:
CALCULATE
(DISTINCTCOUNT('Events'[Offer]),
'Events'[Offer] > SUM('Events'[Target]))
It works when I'm visualizing a table with the PersonID rows, but it doesnt work when I change to the grouped by country view.
Thanks!
I dont see any relationships between these tables.. You will have to first create relationships for the measure to work!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
83 | |
64 | |
61 | |
55 |
User | Count |
---|---|
179 | |
108 | |
105 | |
71 | |
70 |