cancel
Showing results 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

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
3 REPLIES 3
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.

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

In doing so, you are also helping me. Thank you!

Proud to be a Super User!

Announcements

#### 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.

Top Solution Authors
Top Kudoed Authors