Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Solved! Go to Solution.
@Greg_Deckler I have just used the filter to only show total visitors when the value is "not blank" and that has fixed it for me.
Thank you for your help with everything though!
@Lukep What do your measures look like? Generally you can use something along these lines:
Measure Average = AVERAGEX( ALL('Table'), [Value] )
@Lukep Try:
AverageFootFall = AVERAGEX( ALL('Priority Zone'), [total visitors] )
Your other measures can remain the same.
@Greg_Decklerthe only issue is when i do that, the average stays the same regardless of what i select on the slicers. So it is not dynamic as I wish it to be. The graph also becomes quite gapped.
@Lukep Use ALLSELECTED then instead of ALL. So like:
AverageFootFall = AVERAGEX( ALLSELECTED('Priority Zone'), [total visitors] )
@Greg_DecklerThanks that has worked, the only thing now is the graph still looks like this.I dont suppose you know how i would go about making it so there was no gaps between the bars when only selecting one day?
Thanks for your help.
@Lukep Ah, well, you could try changing the x-axis to categorical instead of continuous.
@Greg_Deckler I have just used the filter to only show total visitors when the value is "not blank" and that has fixed it for me.
Thank you for your help with everything though!
@Lukep That's a great solution!
User | Count |
---|---|
98 | |
91 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |