Measure with multiple conditions

[stefanymonteiro]

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!!!

[Dangar332 · Accepted solution]

hi, @stefanymonteiro 
@stefanymonteiro 

these output achieve 

use below measure

result =

var a = max(a1[minimum])

var b = sum(a2[value])

var c = max(a1[charge?])="yes"

var e = sum(a1[monthly value])

var d = if(c=TRUE(),IF(a>b,a+e,b+e),0)

return d

adjust tour table name

but i have question regard these 

is there table present of these value ?

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[stefanymonteiro]

Hi, @some_bih 
Exactly!!

[some_bih]

Hi @stefanymonteiro 

Question: register table contains only unique combinations for columns Client ID and  Client Name, like for Client A (Client ID=1) is only shown once in register table?

[some_bih]

Hi @stefanymonteiro did you have time to check proposed solution?