add two measures

[Anonymous]

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

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

[Anonymous]

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

[Anonymous]

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

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

[PaulDBrown]

@Anonymous 

I'm not all too sure what you are trying to achieve. Please read this thread to help us help you:

How to get your question answered quickly