Filter by multiple values with multiple fields

[Jack2of3]

I have created about 40 measures in PBI but need them to display on rows. I have found I need to either do the calculations in the database query or via Power Query. I prefer Power Query for the self management (speed of changes).

I have not been able to find anything on filtering using multiple values for multiple fields.

This is the DAX Measure formula. How would it be written in Power Query "M"?

= CALCULATE (

SUM ( 'GL_BALANCES'[CLOSING_AMOUNT] )/ 1000 ,

'Funds',

'Funds'[FUND_GROUP] = "Debt Service Fund" , FILTER('Accounts','Accounts'[TYPE_DESCR] IN {"A010_Cash and cash equivalents - restricted-current", "A025_Investments - restricted-current", "A030_Investments - restricted-noncurrent", "A015_Cash and cash equivalents - restricted-noncurrent"} ))

[Jack2of3]

DOHH!.😲

Thanks Pat. I was using the Matrix visual and completley skipped the option.

[Anonymous]

This is easily done via the GUI filtering dialogue. Just click on the drop down at the top of the column, select the filter options, then advanced. You can change those drop downs from value to column, and change "and" to "or" and chain your filters together pretty easily.

--Nate

[mahoneypat · Accepted solution]

FYI that the matrix visual has a format option called "Show On Rows" that may simplify things.  If that doesn't work, please describe your scenario further, to confirm that you need to transform your data.  You should not need to do calculations like this in your query (DAX is the way to go).

Pat