Cumulative value of unique items with filter

[Cosik]

Hi,

I try to create cumulative line of unique value for selected period.

It is next step of this topic https://community.powerbi.com/t5/Desktop/Create-Cumulative-line-from-measure/m-p/1002230#M475697

I have this:

Totals (Cumulative WOs) =

SUMX (

FILTER ( ALLSELECTED ( 'MDS current' ), 'MDS current'[RFS Week] <= max ('MDS current'[RFS Week]) ),

([Totals (WOs)])

)

Where:

Totals (WOs) =

COUNTROWS('MDS current')

Now I create such measure:

Unikatowe WO =

DISTINCTCOUNT('MDS current'[WO #])

*MDS current'[WO #] - each fild in this column contain some value

When I replace Totals (WOs) in to Unikatowe WO

Totals xxx (Cumulative WOs) =

SUMX (

FILTER ( ALLSELECTED ( 'MDS current' ), 'MDS current'[RFS Week] <= max ('MDS current'[RFS Week]) ),

([Unikatowe WO])

)

I have still the same Cumulative Value. It looks like the DISTINCTCOUNT is not working.

I compare all result, below you can see the table for selected period:

[amitchandak · Accepted solution]

@Cosik , try like

Totals xxx (Cumulative WOs) =
calculate ([Unikatowe WO],
FILTER ( ALLSELECTED ( 'MDS current' ), 'MDS current'[RFS Week] <= max ('MDS current'[RFS Week]) ),

)

[Cosik]

Come on, it was so simple?

I don't like it, when the answer is so trivial.

Thx for help.

[sanimesa]

@CosikCan you try using countrows with values instead of distinctcount and see if it helps? See this article for example:

https://docs.microsoft.com/en-us/dax/values-function-dax

=COUNTROWS(VALUES('InternetSales_USD'[SalesOrderNumber]))  

[Cosik]

The result it still the same.

Unique value are good but cumulative value is still the same.

The synta still don't recognize measure for unique value. 😕

I try also add this diractle to Cumulative syntax but is even worse.