How In Total of matrix display average of column defined as measure

[Alex_G7]

Hi, 

I have measure 

% Perf Inc =
IF(NOT(ISBLANK([Measure1])),1-[Measure1]) -- formatted as percentage

I created Matrix 

I want in Total dispaly average =  88.9%

Thank you

[v-xulin-mstf · Accepted solution]

Hi @Alex_G7

You can try measure as:

Measure=
var a = 
IF(NOT(ISBLANK([Measure1])),1-[Measure1])
var b = averagex()// Expressions that you expect to total
Return
 IF(
    HASONEVALUE([RESPONSABLE]),
    a,
    b
   )

You can refer: https://docs.microsoft.com/en-us/dax/hasonevalue-function-dax

Best Regards,

Link

[selimovd]

Hello @Alex_G7 ,

the value in the cell for total will give back 1-[Measure1].

To be honest I don't have any clue how the [Measure1] looks like, so I don't know if the result makes sense.

But if you want to give back a different result for the total try the ISINSCOPE function:

% Perf Inc =
IF(
    ISINSCOPE( myTable[RESPONSABLE] ),
    IF(
        NOT (
            ISBLANK( [Measure1] )
        ),
        1 - [Measure1]
    ),
    1 - AVERAGE( [Measure1] )
)

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[Alex_G7]

% Perf Inc =
IF(
ISINSCOPE( myTable[RESPONSABLE] ),
IF(
NOT (
ISBLANK( [Measure1] )
),
1 - [Measure1]
),
1 - AVERAGE( [Measure1] )
)

The AVERAGE function only accepts a column reference as the argument number 1.