Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |