DAX - Return average value in table (or chart) of new measure

[Anonymous]

Hello everyone,

I'm using DAX to create a new measure to calculate the percent based on the formula below:

The result return of each individual is correct. However, I want to show the AVERAGE in total, not SUM. My expectation is the table (or chart) will show the average result of 95.7%, instead of 99.92% 

But, I can't find the solution to change it (try to click to Values box to change). Anyone can help me?

[Anonymous · Accepted solution]

Hi @Anonymous ,

You can create another new measure as below and check and check whether it can get your expected result.

Measure =
IF (
    ISINSCOPE ( 'Master1'[Chi tieu KPI] ),
    [Ty le% chinh xac cua du lieu dau vao],
    AVERAGEX (
        VALUES ( 'Master1'[Chi tieu KPI] ),
        [Ty le% chinh xac cua du lieu dau vao]
    )
)

If the above ones can't work, please provide some sample data from the Master1 table with Text format and your expected result with calculation logic and special example screenshots. It is better if you can share a simplified pbix file with me. Thank you. You can refer the following thread to upload your file in the community:

How to upload PBI in Community

Best Regards

[Anonymous · Accepted solution]

Hi @Anonymous ,

Whether your problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.

Best Regards

[Anonymous · Accepted solution]

Hi @Anonymous ,

You can create another new measure as below and check and check whether it can get your expected result.

Measure =
IF (
    ISINSCOPE ( 'Master1'[Chi tieu KPI] ),
    [Ty le% chinh xac cua du lieu dau vao],
    AVERAGEX (
        VALUES ( 'Master1'[Chi tieu KPI] ),
        [Ty le% chinh xac cua du lieu dau vao]
    )
)

If the above ones can't work, please provide some sample data from the Master1 table with Text format and your expected result with calculation logic and special example screenshots. It is better if you can share a simplified pbix file with me. Thank you. You can refer the following thread to upload your file in the community:

How to upload PBI in Community

Best Regards