Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

New Member

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
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
Community Support
Community Support

HI @viviana_obando,

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 

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
New Member

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

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

Community Champion
Community Champion



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 

Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.

Helpful resources

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.


Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.


Fabric certifications survey

Certification feedback opportunity for the community.