Count measure results based on conditions/Create a Table based on measure results to make a donut ch

Hi Anonymous 
The disconnected filter table is a table that contains all the unique statuses (the 3 flags) you can create it in excel along with numeric sorting column (required only to sort the flag column in the visual in the desired order) or you can use the folowing code to create a calculated table using DAX

Fiter Table =
VAR T1 =
    SELECTCOLUMNS ( GENERATESERIES ( 1, 3, 1 ), "Sort", [Value] )
VAR T2 =
    ADDCOLUMNS (
        T1,
        "Flag", SWITCH ( [Sort], 1, "FlagHigh", 2, "FlagMedium", 3, "FlagRed" )
    )
RETURN
    T2

This table has NO RELATIONSHIPS with any other table in your model. You just need to use it to slice by in your visuals, for example to place it in the rows of a matrix visual or use it in a slicer.

Once this table is created, place the [Flag] column in a table visual then place the following measure along with it.

Flag Count =
VAR CurrentFlag =
    SELECTEDVALUE ( 'Filter Table'[Flag] )
VAR T1 =
    ADDCOLUMNS ( VALUES ( TableName[Project Name] ), "@Flag", [MeasureName] )
VAR T2 =
    FILTER ( T1, [@Flag] = CurrentFlag )
RETURN
    COUNTROWS ( T2 )