Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
How can we create the sum of measure. I tried calculate(sum(measure))
giving error.
Thanks.
A measure is really an aggregate value that gets contextually filtered based upon interaction with other visualizations and filters. Therefore, if you put a measure on a card and remove all filters, it has its total maximum value. It shoulds like you want something a little different. Can you provide more information about what you are trying to accomplish, some sample data and expected result?
I have a similar issue. Trying to calculate the number of support tickets I had open over a month.
In short my table looks like
Name open date closed date
I have got my open tickets by counting the count(open date) - count(closed date)
What I would like to acheive is to getting the sum total of these open cases per month, so its easy to see if the number of outstanding cases is increasing or decreasing.
Is there anyway to Sum the number of cases per month?
User | Count |
---|---|
102 | |
88 | |
78 | |
71 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |