Forum Discussion

AhmedIqbal's avatar
AhmedIqbal
Frequent Visitor
6 years ago
Solved

If condition based on different tables in power bi

Hello,  I am currently working on a dashboard for Accounts Payable. This is to show the live statistics of invoices and who they are allocated to. The invoices are allocated to analysts per the comp...
Need Help
  • BA_Pete's avatar
    BA_Pete
    6 years ago

    Hi AhmedIqbal ,

     

    This is because you have also changed your Cross Filter direction between Allocation and Supplier to 'Single' in your file, whereas it was 'Both' in the screenshot you provided.

     

    Pete

AhmedIqbal's avatar
AhmedIqbal
Frequent Visitor
6 years ago

Hey Pete, 
I'm getting this error when I used the below formula.

 

dax's avatar
dax
Icon for Community Support rankCommunity Support
6 years ago

Hi  AhmedIqbal , 

When you use measure , you need to use aggregate expression in expression , you could try "if(isblank(min([column])), [columnB])". By the way, I am not clear about your requirement, if possible could you please inform me more detailed information(such as your expected output and your sample data )? Then I will help you more correctly.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

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

 

  • AhmedIqbal's avatar
    AhmedIqbal
    Frequent Visitor
    6 years ago

    Hi Zoe,
    You can access the power bi file via this link. Power Bi File 
    I am trying to create a new column that will pull the name based on the Allocation and Reallocation. If data is present in Reallocation, then use that name. If not present, then use the Allocation name.