Forum Discussion
Incremental CountIF DAX
I have a formula in excel that is =COUNTIF($P$2:$P2,P2) and have been looking around the forums for a replica in PBI but am having no luck. Is anyone able to help me.. What the desired result is ...
Hi
You can add an Index column starting with 1 in your query. This will have unique value for each row.
Post this create calculated measure as
Running Count =
CALCULATE(
COUNT('Table'[ID]),
FILTER(All('Table'), 'Table'[Index]<=MAX('Table'[Index])),
VALUES('Table'[ID])
)