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.
Hi,
I'm trying to make a report which shows how many sites have been visited per time period (not actually a month, but close enough), vs the target for that period.
I have a table which shows the frequency target, and a second table which shows all the individual site visit data. What I'm having difficulty is linking the two together to see how many total visits have been made in a period. I've managed to set my coverage so I can tell whether a site has been visited at all, but not to the correct frequency.
Below is an example of the data I have:
So for P1, Site 1, I want a Frequency Actual value of 3; for P1, Site 2, a Frequency Actual value of 2; for P1, Site 3, a Frequency Actual value of 1 and so on.
Any suggestions?
Thanks!
Solved! Go to Solution.
Try this Calculated Column
Frequency Actual = CALCULATE ( COUNTROWS ( VisitData ), FILTER ( VisitData, VisitData[Site Code] = Targets[Site Code] && VisitData[Visit Period] = Targets[Period] ) )
Try this Calculated Column
Frequency Actual = CALCULATE ( COUNTROWS ( VisitData ), FILTER ( VisitData, VisitData[Site Code] = Targets[Site Code] && VisitData[Visit Period] = Targets[Period] ) )
Fantastic, thanks! I'd tried a lot of different filter types, but the double amphersand was the step I was missing.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
92 | |
88 | |
70 | |
69 |
User | Count |
---|---|
228 | |
128 | |
117 | |
83 | |
82 |