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 su...
Need Help
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?