Compare measures to category

[Anonymous]

Hello!
I have a problem,
I use a stacked area chart on a date-axis with a few categoty-filters like this:

I want to add a measure on top. 
How do I do that? The only place i can add a measure on is in tooltips:

[selimovd]

Hey @Anonymous ,

why can't you add it to the values field?

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[Anonymous]

@selimovd 
That is my question. When I try to add a measure, it just replaces the column.
Could it be because of the legend somehow?

[v-kkf-msft]

Hi @Anonymous ,

You are right. If you add a lengend, then you can only add a field in the Values pane. I think you need to replace the legend with measures, like this: 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

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

[Anonymous]

Thank you. It would solve the issue but its very clunky.

[v-kkf-msft · Accepted solution]

Hi @Anonymous ,

There is another way, I don’t know if you accept it.

First create a separate table:

Category = 
UNION(
    DISTINCT('Table'[KPI - Category]), 
    {"1S or lower"}
)

Then use the following measure:

Measure = 
IF(
    MAX(Category[KPI - Category])= "1S or lower",
    [1S or lower],
    CALCULATE(
        SUM('Table'[Value]),
        FILTER( 'Table', 'Table'[KPI - Category] = MAX(Category[KPI - Category]) )
    )
)

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

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