request
2 Topics
Measure with multiple conditions
Hello, just getting back to power bi after a while, and I have the following problem and data: I have this table as if a register table Client Id Client Name Charge? Minimum Monthly Value 1 A Yes 1000 1000 2 B Yes 2000 0 3 C No 3000 0 4 D Yes 0 0 5 E Yes 0 2000 And this table as if a transactions table Client ID Client Name Value 1 A 500 1 A 200 2 B 1500 2 B 700 3 C 300 4 D 200 5 E 100 5 E 300 For those who have Charge? = Yes, then I should see if they have a Minimum value. If they do, when the transactions SUM > Minimum, then I should Charge the SUM value. If SUM < Minimum, then I should Charge the Minimum. Also if they have a monthly value I should add it to this result (SUM+Monthly or Minimum+Monthly). If I dont have a Minimum, them I should just Charge the SUM+Monthly if they have it or just the SUM. With these examples and rules, I want the following results: I want how much I should charge for each client for those who have Charge? = Yes, so something like: A 2000 B 2200 C 0 D 200 E 2400 I want the sum of all charges, so something like: 6800 And I want to show how much im charging for each charge type, so something like: Transactions 2800 (only the values that passed the minimum) Minimum 1000 (only the case when transactions<minimum) Monthly Value 3000 I used this examples since I cant share my original data, but its a loooot of transactions, so using measures that would be more fluid would be better!! Thank you in advance!!!Solved971Views0likes4Comments
