Create measure % of total complete for a subset of records in a table

[Anonymous]

Hi,

I am trying to create individual cards for each business region and show how many of the servers have been patched

Host	Region	Patched
A11	AMERICAS	Yes
A45	AMERICAS	No
E55	EMEA	Yes
E34	EMEA	Yes
E44	EMEA	No
E67	EMEA	Yes

Card should show "50% of all AMERICAS hosts patched"

[nandic · Accepted solution]

Hi,

Demo file attached.
This is example of calculated column using dax:

Result:

Counter =
VAR _totalRows =
    CALCULATE (
        COUNTROWS ( RegionTable ),
        FILTER ( RegionTable, RegionTable[Region] = EARLIER ( RegionTable[Region] ) )
    )
VAR _totalPatchedRows =
    CALCULATE (
        COUNTROWS ( RegionTable ),
        FILTER ( RegionTable, RegionTable[Region] = EARLIER ( RegionTable[Region] ) ),
        FILTER ( RegionTable, RegionTable[Patched] = "Yes" )
    )
RETURN
    FORMAT ( DIVIDE ( _totalPatchedRows, _totalRows ), "0%" ) & " of all " & RegionTable[Region] & " hosts patched"

Regards,
Nemanja Andic

[Anonymous]

Thank you Nemanja! This is exactly what I was looking for!