Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am trying to plot an accumulative count. When one value is missing in the X-axis, it is replaced by the total value of the counting. I have been trying to fix this setting the VALUES() parameter. But when I do that I can not use the filters with more than one column. Is there something wrong in the following code?
N_acum= CALCULATE(sum(data[NumBills]);filter(ALLSELECTED(Data);data[MDays] >= max(data[MDays])))
N_acum= CALCULATE(sum(data[NumBills]);filter(ALLSELECTED(Data);data[MDays] >= max(data[MDays])); VALUES(data[ID]))
the structure of the data base is like that:
thank you in advance
Solved! Go to Solution.
I selected Mdays for Axis and N_acum for Line chart as below. Is it same as your chart?
BTW, what do you mean “one value is missing in the X-axis”?
Best Regards,
Herbert
Could you please provide your table structure and which columns/measures do you select in the visual chart?
I try to repro your problem according to your measure formula but have no success.
Best Regards,
Herbert
hi Herbert, I've already changed the original message.
thank you for your help
I selected Mdays for Axis and N_acum for Line chart as below. Is it same as your chart?
BTW, what do you mean “one value is missing in the X-axis”?
Best Regards,
Herbert
It work, I didnt't understand correctly the values parameter, sorry...
Thank you for your help
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |