Beginner - Problem with the result of a simple measurement

[PeterPain]

Hi guys - i just started with PowerBI Desktop and watched a couple of tutorials.

I created an "easy" measurement to calculate a %-Value from two-KPis. 

Rate = DIVIDE('KPI'[Loss AI],'KPI'[Adreq.])

The result into a table is correct as long i choose "Rate = not summarize":

The Problem is -> i want just one result and if i choose "summary" the calculation is wrong.

What is the problem to get the right result on the needed aggregation level?

[Anonymous · Accepted solution]

Hi @PeterPain 

You can try the following measure

Rate =
VAR a =
    SUMX (
        FILTER (
            ALLSELECTED ( 'KPI' ),
            [Datum]
                IN VALUES ( 'KPI'[Datum] )
                    && [SEITE] IN VALUES ( 'KPI'[SEITE] )
        ),
        [Loss AI]
    )
VAR b =
    SUMX (
        FILTER (
            ALLSELECTED ( 'KPI' ),
            [Datum]
                IN VALUES ( 'KPI'[Datum] )
                    && [SEITE] IN VALUES ( 'KPI'[SEITE] )
        ),
        [Adreq.]
    )
RETURN
    DIVIDE ( a, b )

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PeterPain]

Hi and thx for your answer. "Rate" is a measure already 😊

[Idrissshatila]

Hello @PeterPain ,

try converting the table visual into a matrix and have the rate in the values and the other fields as rows.

[Fowmy]

@PeterPain 

Create a meaure instead of column for your calcualtion