cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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

Accepted Solutions
Highlighted
Regular Visitor

Re: Matrix displaying unwanted values at the higher levels

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
Highlighted
Regular Visitor

Matrix keeps aggregating at higher levels

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

 

 

Highlighted
Microsoft
Microsoft

Re: Matrix displaying unwanted values at the higher levels

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

Highlighted
Regular Visitor

Re: Matrix displaying unwanted values at the higher levels

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

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Power BI Desktop August 2020 Update

Power BI Desktop August 2020 Update

We have great updates this month! Click the link for the video with more info.

Top Solution Authors
Top Kudoed Authors