Help with Dax measurement, to replicate the value of a visualization

[Syndicate_Admin]

Hello
I come to you for help to simulate or replicate the value given in the TBLA towards a measurement so that I can use it as an independent measure called "Unused Kilos".

The visualization of the TBLA is as follows:
where it yields a total of "net kilos" = 2,807,415.16 , this TBLA has an object filter which is

Definition of measures used:

The net of the kilos =

SUMX('Weighted by Key',

'Weighted by Key'[kilos net]

)

Unique Combinations =

CALCULATE(

SUMX('Weighted by Key', DISTINCTCOUNT('Weighted by Key'[Comb(KEY)]))

)

I look forward to your help and thank you very much to everyone in advance!

[Syndicate_Admin · Accepted solution]

Solution:

Kilos = Used

SUMX(

FILTER(

SUMMARIZE(

'Weighted by Key',

'Weighted by Key'[Comb(KEY)],

"ConteoCombi", [Unique Combinations]

)

,[ConteoCombi] = 1

)

,[Kilos net]

)

[parry2k]

@Syndicate_Admin check this blog post and also this one.