Creation of a measure regarding count of percentages in a table.

[vcb_001]

Hi,

I'm using a table visual in my dashboard as it is represented in the below, but it is not a data or table that are currently available. I'm just using two columns from a table and 1 measure which has been done by another formula based on a different table's data.

The table looks like this:

Application ID	Application Name	Health Score
11220	XYZ App	100.00%
10200	ABC App	36%
20031	ZRT App	100.00%
23911	KLM App	100.00%
33329	OPR App	40.00%

What I would like to do is quite straigthforward but, it didn't work with the combination of CALCULATE and FILTER formulas. I need to create a measure which counts number of 100.00% Applications to see how many 'fully' healthy applications are there in the table instead of only showing them in the Power BI table.

Additionally, another measure is also needed to calculate unhealthy ones which are basically 'not' %100.

[ERD · Accepted solution]

@vcb_001 , try this measure:

healthy amt =
VAR t = ADDCOLUMNS ( VALUES ( 'Table'[Application ID] ), "score", [Health Score] )
RETURN
    COUNTROWS ( FILTER ( t, [score] = 1 ) )

[vcb_001]

Thank you for your valuable answer!

Could you please also help me to adapt this measure for the ones which are below 100% and above 75% as a new category (new measure)?

[ERD]

lower amt =
VAR t = ADDCOLUMNS ( VALUES ( 'Table'[Application ID] ), "score", [Health Score] )
RETURN
    COUNTROWS ( FILTER ( t, [score] < 0.75 ) )

mid amt =
VAR t = ADDCOLUMNS ( VALUES ( 'Table'[Application ID] ), "score", [Health Score] )
RETURN
    COUNTROWS ( FILTER ( t, [score] < 1 && [score] > 0.75 ) )

[vcb_001]

Hello again,

I greatly appreciate what you've done so far for this measure and it supported a lot to improve the structure of my dashboard. I thought for a new improvement based on the same logic you've shared in the above which is basically a filter that includes 3 categories for example, 'Fully Healthy', 'Mid Healthy' and 'Unhealthy'. How could I do that, Can you please help me either to create this custom column as well as the relevant filter based on that one?