Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Filter the first column of a matrix based on another column

I've downloaded all of the transactions from a Quickbooks file.  The client uses the memo field in almost every entry.


I want to create a Matrix table that has the memo field in the first column, but I only want to pull the memo's from a specific account. 


Is it best to do this by creating a measure for the memo field or by creating a secondary table that filters out the data from the other accounts?


Also, I want to be able to pull the memo's for specific time periods (ie Quarterly).

Super User IV
Super User IV

@gsherbon ,Can you share sample data and sample output in table format?

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources


Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.