Skip to main content
cancel
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.

Reply
newrice
Frequent Visitor

How to add row and column for several set of Measures?

Hi there, 

I have measures like  "Sales YTD" , "Sales LYTD", " %YoY Growth", "AOS YTD", "AOS LYTD", "% YOY AOS". 

How to create a matrix visule to display the information with row label "NNS", "AOS" and column label "YTD", "LYTD", "Growth"?

 

Thank you in advance,

 

1 REPLY 1
Greg_Deckler
Super User
Super User

@newrice You could use a disconnected table for your measure columns and then a single measure that determines which measure to display based on the MAX of your disconnected table column.

 

In general, to use a measure in that way, you need to use the Disconnected Table Trick as this article demonstrates: https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick...


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors