Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
FidelC
Frequent Visitor

Problem plotting accumulative count

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])))

 

preguntaPOWERBI.PNG

 

N_acum= CALCULATE(sum(data[NumBills]);filter(ALLSELECTED(Data);data[MDays] >= max(data[MDays])); VALUES(data[ID]))

 

preguntaPOWERBI2.PNG

 

 

the structure of the data base is like that:

 

preguntaPOWERBI_estructura.PNGpreguntaPOWERBI_datos.PNG

 

 

thank you in advance

1 ACCEPTED SOLUTION

@FidelC

 

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”?

Problem plotting accumulative count_1.jpg

 

Best Regards,

Herbert

View solution in original post

4 REPLIES 4
v-haibl-msft
Employee
Employee

@FidelC

 

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

@FidelC

 

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”?

Problem plotting accumulative count_1.jpg

 

Best Regards,

Herbert

It work, I didnt't understand correctly the values parameter, sorry...

 

Thank you for your help

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.