Forum Discussion

stefanymonteiro's avatar
stefanymonteiro
Frequent Visitor
2 years ago
Solved

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 Valu...
DAX
Need Help
Request
  • Dangar332's avatar
    Dangar332
    2 years ago

    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