Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

add two measures

Good afternoon

I have two measures, the first is a

Cantidad_ATOT - CALCULATE(COUNT('BBDD_HARMONY_DIN (2)'[ATOT DATE]); USERELATIONSHIP('BBDD_HARMONY_DIN (2)'[Time]; EFFICIENCY[Time (Integer)])) (since in this table each row is a data) and the other a calculation of the
QUANTITY2 - CALCULATE(SUM(EFFICIENCY[ADR CAP]); USERELATIONSHIP('BBDD_HARMONY_DIN (2)'[Time]; EFFICIENCY[Time (Integer)])) from another table (since in this row each row already has a sum). At last the result of the two measures is a sum.
By graphing it looks like this
mm.PNG
But I need Unknown, N/A, Non-regular, and Regular to be left in a grouped column.
I know I have to put kind of avian in legend, but at the moment I do that, it just lets me put a measure in value for you. So I don't know what to do. Thanks a lot

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thank you very much, I'm going to improve the question.

    Thankio to everyone, I´m going yto impruve my doubts.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    HI Anonymous,

    AFAIK, current power bi does not allow you to use multiple values and legend fields at the same time.

    In my opinion, I'd like to suggest you create a new table with two category names as your measure formula names.
    You can use it on the axis of your chart, add the column which you mentioned to the legend field.
    After these steps, you can write a measure formula with a switch function to calculate based on the current axis and legend category to summary records and show value.

    DAX – Making the “Case” for SWITCH() 

    If these not help, you can share some dummy data with raw data structure and expected result to help us clarify your requirement and test coding formula.

    How to Get Your Question Answered Quickly 
    Regards,

    Xiaoxin Sheng