Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to use expression in powerbi

Hello

I have matrix in PowerBi of portfolio values..  In the data there is a column for 'moves', 'groupcoa' and the values are GBP.

I just want a subset of this data for Capitalised Interest such that I only bring back the GBP values where moves = ICAPI or ICPIK ans the account is in 1301,1351,1361,1401,1461.  In Qlikview i would have put this in an expression as below in the matrix

sum({<moves = {"ICAPI", "ICPIK"}, groupcoa = {"1301","1351","1361","1401","1461"}> }GBP)

In powerbi, how would you do this? Would you add a column into the data query or create a measure or do you have to hardcode the filters?  Many thanks Paul

 

 

  • You can apply these filters using the filter pane of the visual or you can create a measure to calculate this.

1 Reply

  • You can apply these filters using the filter pane of the visual or you can create a measure to calculate this.