 Right now I have a set of data in PowerBI as shown in the screenshot above. I have a Measure to calculate the % of OK:

```total_student = COUNT(StudentAns[Name])

ok_% =
VAR OK_COUNT = COUNTROWS(
FILTER(
StudentAns,
)
)

RETURN (OK_COUNT/StudentAns[total_student])
```

I created a Matrix to show the % of OK for each month as shown in the screenshot below: The average percentage for all of the months is what I'm looking for. As a result, the final output response should be 89.05 percent, which is calculated as the average of 85.95 percent, 91.4 percent, 89.27 percent, and 89.58 percent.

Because I want to use the result as a Target Goals for KPI visualisation, I want to get the average % of OK throughout all of the months. Feb 23 in Power BI 246 views

## 1 answer to this question.

You can add one more measure to the matrix as follows:

```ok_2 % =
IF(
HASONEVALUE( 'StudentAns'[Month] ),
[ok_%],
AVERAGEX(
VALUES( StudentAns[Month] ),
[ok_%]
)
)```

It calculates your original measure for each month, but it returns the average of your measure's results for the Totals.

HASONEVALUE is a function that returns a value. True if the filtered context contains just one distinct value; AVERAGEX calculates the average of a series of expressions evaluated in each row; VALUES provides a list of distinct values. answered Feb 23 by
• 4,360 points

## How to calculate average inventory in power bi?

Hi @There, Is there any index field in ...READ MORE

## Using DAX calculation how to calculate monthly budget till today in power bi Desktop?

You can make use of this: MTD Budget ...READ MORE

## How to measure in DAX to calculate YTD for chosen month only for Power BI?

If you use the date column from FactTable, ...READ MORE

## To Calculate the Standard Deviation in Power BI

Suppose you've to obtain the Standard Deviation ...READ MORE

+1 vote

## Unable to install connector for Power Bi and PostgreSQL

I think the problem is not at ...READ MORE

## Migrate power bi collection to power bi embedded

I agree with Kalgi, this method is ...READ MORE

+1 vote

## Connect power bi desktop to dataset and create custom reports

Yes using Power BI REST API to ...READ MORE