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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
lbecerra
Regular Visitor

Matrix displaying unwanted values at the higher levels

matrix1.JPG

 

 How do i get my matrix to not show the email address and gender at the higer levels -- State and city. As the above clip from a training site demonstrates. When I create a matrix it places the higher levels on separate lines and tries to get a value for each (first of, max etc. ). I do not want this. see below striked out values I do not want the yellow values to appear on the matrix. Thanks in advance!

 

matrix2.JPG

see below

1 ACCEPTED SOLUTION

nope that was not the solution. Obviously my question was misunderstood. I figured it out -- formatting turn off subtotals - problem solved.!

View solution in original post

3 REPLIES 3
v-ljerr-msft
Microsoft Employee
Microsoft Employee

Hi @lbecerra,

 

If I understand you correctly, you should be able to create a measure using HASONEVALUE function to check if it is in the lowest level then show the email address and gender accordingly. The formula below is for your reference. Smiley Happy

measure =
IF (
    HASONEVALUE ( 'Table1'[CustomerName] ),
    FIRSTNONBLANK ( 'Table1'[EmailAddress], 1 )
)

 

Regards

nope that was not the solution. Obviously my question was misunderstood. I figured it out -- formatting turn off subtotals - problem solved.!

lbecerra
Regular Visitor

matrix2.JPG

 

I dont want aggregate values at the county (Atlantic) and city levels (Absecon) see below. (first project type, first pop type)  highlighted in yellow. How do I stop this. I have indicated that project type and pop type are "do not summarize". The values only belong to the lowest level (i.e., Clayton mill Run) .

 

 

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.