Forum Discussion

sivashankr's avatar
sivashankr
Icon for Helper II rankHelper II
6 years ago
Solved

please help on NULL Calculation

Hi Team, I have 2 tables 'Table A' and 'Table B'. I joined these 2 tables using M to 1 cardinality. Now the requirement is I've calculation "Valid Customer ?: if Table B.Customer is null then N e...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    6 years ago

    sivashankr 

    There is no blank customer in table B and you are checking if there is any blank in table B

    I think Table A has a bigger customer group than table B. So you need to create that column in table A

    please try this

    validcustomer = 
VAR CUS=LOOKUPVALUE('Table B'[CUSTOMER],'Table B'[CUSTOMER],'Table A'[Customer])
return if(ISBLANK(CUS),"No","Yes")

     

v-xicai's avatar
v-xicai
Icon for Community Support rankCommunity Support
6 years ago

Hi sivashankr ,

 

You may change the Cross filter direction of relationships among the tables above from Single to Both , which will take these tables treated as a single table. See more:Create and manage relationships in Power BI Desktop .

 

Best Regards,

Amy 

 

Community Support Team _ Amy

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