Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Filtering to a deeper lvl not working

Hey guys, 

 

I have a sample database with customer ID´s and reasons why they have to pay more. If one coloumn is = 0, then another should also show 0, if it is not = 0 , I want to calculate the sum of the reasons. Here comes the problem. I want to be able to filter down on one customer which doesn´t work and I don´t  know why. 

 

ZZ_ep = CALCULATE(Sum('Report'[Betrag]),FILTER(ALL('Report'),'Report'[ID]=11)) - Measure to calculate the amount (Betrag) for reason 11 
 
vRPÜ ep = IF('Properties'[PÜ_Kalk]= 0,0,(_Measures[Zieg]+_Measures[ep]+_Measures[ZZ_ep]+_Measures[UK_ep_]+[OPT_ep_all_Mod])) -> Coloumn -> IF pü_kalk = 0 then 0, else the sum of the other ones.
 
Thank you! 
Need Help

4 Replies

  • Dhacd's avatar
    Dhacd
    Icon for Resolver III rankResolver III
    4 years ago

    Hi,

    Please copy the table and paste it into the comment box so that it is easier to understand.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      This is a little screenshot which shows the problem. vRPÜ_ep sums up all values over all customers and it does not calculate only the value from person "xyz" 

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    Anonymous , try like

     

    Switch(True() ,
    isblank('Properties'[PÜ_Kalk]) , blank(),
    'Properties'[PÜ_Kalk]= 0,0,
    (_Measures[Zieg]+_Measures[ep]+_Measures[ZZ_ep]+_Measures[UK_ep_]+[OPT_ep_all_Mod])
    )

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Thought about a switch as well but same result. Thanks anyway. 

       

      How important is the fact that the reasons for paying more and PÜ_Kalk are in different tables?