Forum Discussion
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
- jennratten
Super User
You can apply these filters using the filter pane of the visual or you can create a measure to calculate this.