Forum Discussion

PowerBi_18's avatar
PowerBi_18
Frequent Visitor
8 years ago
Solved

Using two smart filters

Hello there, apologies if this is a simple question, I am new to DAX and Power Bi. The purpose of my code is to show gross profit. I have three filters on the dashboard, which should adjust the gross...
PowerBi_18's avatar
PowerBi_18
Frequent Visitor
8 years ago
TLDESCPersonGross Profit
Conference 1Person 1-10
Conference 1Person 1-30
Conference 1Person 2-15
Conference 1Person 2-6
Conference 1Person 2-1500
Conference 1Person 2-2000
Conference 1Person 3-500
Conference 1Person 3-100
Conference 1Person 4-25
Conference 2Person 1-100
Conference 2Person 2-60
Conference 2Person 2-20
Conference 2Person 5-50
Other costsPerson 6-5000
project 1person 125000
project 2person 410000
project 3person 512500

Hi, thanks again for looking at ths. So I've written up a basic tabe of what is happening. If we filtered on Person 6 AND Conference 1, we would want to add the 9186 (sum of conference 1 and person 6) to the total gross profit. In effect, seeing what the result would be without one off costs (conference) and without person 6 being busy.