Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello all,
I am trying to create a measure where I should get the average of tickets created / total headcount for each city (I am able to do that).
Issue comes up when all cities are selected from slicer and it shows me the total of all cities, instead of overall average. I have shared a Power BI file with sample data and required output is mentioned at the bottom of file.
Sample Power BI file is available at below location:
Do let me know, if more clairty is required.
The model wasn't accurately defined. Data and Headcount shall be linked by both City and Month
Necessary update of formulas as below:
@nitinbalodi hi create a new measure and add that measure to that measure to the cards where you wanted to display
If you wan to make it Dynamic, create Measures as follows
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |