Cumulative of an undated ID count

[Syndicate_Admin]

Hello.

I need a cumulative of an ID count I already have, but I'm not using dates for the count, I'm using a group I made.

The group:

The ID count:

IDs Count = COUNT('Din Table'[ID])

And I get the following:

But I'd like to do the cumulative something like that I did in excel.

Best regards.

[Syndicate_Admin · Accepted solution]

Hello

I already managed to do it using the "Quick Measure" function inside I selected the values I required and it gave me this DAX:

Total acumulado de Recuento IDs en CQI_SUM Bins = 
CALCULATE(
	[Recuento IDs],
	FILTER(
		ALLSELECTED('Tabla Din'[CQI_SUM Bins]),
		ISONORAFTER('Tabla Din'[CQI_SUM Bins], MAX('Tabla Din'[CQI_SUM Bins]), DESC)
	)
)

[muhammad_786_1]

Hi @Syndicate_Admin 

You can find the solution by following the steps provided in this post:

https://community.fabric.microsoft.com/t5/Desktop/Cumulative-Total/td-p/43115

Best Regards,
Muhammad Yousaf

If this post helps, then please consider "Accept it as the solution" to help the other members find it more quickly.

LinkedIn