Measures to calculate Count & Percentage based on summarised values

[geo_lan]

Hello,

I am looking for assistance please regards to the creation of 2 measures (to be used in card visuals) - one that displays a Count of Cost Centres (AB_CC) that are within budget, and another that displays the percentage of cost centres that are within budget. Please see below screenshot of an example table (ACCOUNT_BALANCES) to illustrate my issue:

From this table we can see the total variance for each cost centre is as follows:

So in total,   3 Cost Centres are under budget, which is   60% of all cost centres. These are the 2 measures I would like to formulate please if possible.

I have attempted some DISTINCTCOUNT and FILTER formulas, but in the case of the Count summation they keep returning a result of 4 which is incorrect.

Thank you

[ryan_mayu · Accepted solution]

@geo_lan 

Pls try this

Measure =

var T=SUMMARIZE('Table','Table'[AB_CC],"ACTUAL2",SUM('Table'[ACTUAL]),"BUDGET2",SUM('Table'[BUDGET]))

RETURN COUNTROWS(FILTER(T,[ACTUAL2]<[BUDGET2]))

Measure 2 = [Measure]/DISTINCTCOUNT('Table'[AB_CC])

pls see the attachment below

[geo_lan]

Yes that works, nice one ryan_mayu! Thank you

[ryan_mayu]

you are welcome