Forum Discussion
larabraghetti
Helper II
10 years agoDAX: sum with filters
Dear all, I need some help in order to built a formula in my DB. My table "Pos" is structed in this way: Column: Portfolio, Isin Code, Value I'd like to have a sum of Value for each Isin c...
- 10 years ago
larabraghetti
Helper II
10 years agoAny idea?
I'm blocked on this topic...
kcantor
Community Champion
10 years agoBuild the column as you would if the row only exists one time. Then, when pulling it into PowerBi visualizations, use the portfolio/isin/ column labels as your axis or row on the matrix. Just use the column headings instead of the cell references you would in excel. You may initially get an error about no row reference existing but, often times, this is overcome when you add it to the visualization.
Unfortunately, I am not able to see the images you are sharing today as I am on my mobile but the gist of what I am reading is that you want a specific column calculation that can be combined based on the portfolio. The visualization rows/axis will handle that part.
- Sean10 years ago
Community Champion
- larabraghetti10 years ago
Helper II