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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
jsangerman
Helper I
Helper I

Matrix is filtering on row total instead of column values

I have what I think is a simple matrix. Looks like this:

jsangerman_0-1685124940630.png

Looks like this (row headers intentionally cut off):

jsangerman_1-1685125013307.png

 

I want to see only allocations less than 1. In other words, I want to see only the sum of Allocations for each Team Member/Month combination that is less than 1. However, when I apply this filter:

jsangerman_3-1685125237944.png

I see this:

jsangerman_2-1685125138389.png

What's missing from the results are values less than 1 but with a row total  greater than 1. It's filtering based on the row total instead of the individual column values.

 

What gives? And how can I filter based on the column values?

1 REPLY 1
jsangerman
Helper I
Helper I

Bump. I figured this one would be easy.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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