Distinct count of min by category

[PowerdriveX6]

Dear Gurus,
I have stucked on how to get distinctcount of minimum by category.
Sample of source data shared at GoogleDrive.

I build visualisation via matrix and got distinctcount of all StateExt by Components.
But how can i get MIN value of each Area/Family from within all this Area/Family components?

In filtered sample, by required solution logic its should give me Area_A/Family_1/1_Top = 22, Area_A/Family_1/2_Mid=1

Pic.1

In other words, i want to remove from matrix row Component and instead of 89 for 1_Top get 22 and for 2_Mid instead 20 get 1 (as a minimals from the logic in previous sentence):

Pic.2

I have look over this forum and found some similar requests, but its differ a little and im as newbie for such deals stucked in adopt solutions for my case.

[AlB · Accepted solution]

Hi @PowerdriveX6 

Create a measure and place it in the last visual. See it all at work in the attached file.

Measure =
MINX (
    DISTINCT ( SourceTable[Component] ),
    CALCULATE ( DISTINCTCOUNT ( SourceTable[EquipmentID] ) )
)

Please accept the solution when done and consider giving a thumbs up if posts are helpful.  Contact me privately for support with any larger-scale BI needs, tutoring, etc.

[PowerdriveX6]

Work perfect, already adopted to original model.
My error was in wrong wrapping of Distinct and Calculate into MinX, now i got logic of this measure.
Thanks a lot, @AlB !