improvement rates for workers and supervisors

[acnt_schartner]

Hi,

i have a measure that calculates an improvement rate for workers but i want to exclude the supervisors from this measure and give them a rate based on the average of all workers.

Is there a way to do this with measures only. This calculation is rather complex and if i try to add this as a column i get a RAM-Error (i got 16GB)

Thanks in advance.

[v-alq-msft · Accepted solution]

Hi, @acnt_schartner 

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

Table:

You may create a measure as below.

Improvement Rate = 
SUMX(
    SUMMARIZE(
        'Table',
        'Table'[EmpID],
        'Table'[Category],
        "Result",
        IF(
            [Category]="worker",
            DIVIDE(SUM('Table'[Value1]),SUM('Table'[Value2]),0),
            AVERAGEX(
                FILTER(
                    ALL('Table'),
                    'Table'[Category]="worker"
                ),
                DIVIDE([Value1],[Value2],0)
            )
        )
    ),
    [Result]
)

Result:

Best Regards

Allan

If this post helps,then consider Accepting it as the solution to help other members find it faster.

[amitchandak]

@acnt_schartner ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[acnt_schartner]

I can not reply with tables "Post flooding detected"