Forum Discussion

Rochejf's avatar
Rochejf
Frequent Visitor
3 years ago
Solved

Return yes when all rows are filled

Hi guys, I'm wondering whether this can be done in Powerbi?   Referring to the table below.   I have 3 sales orders each separate into different sales tasks. What I wish to do now is, when all sa...
Need Help
Tips and Tricks
Tutorial Requests
  • ryan_mayu's avatar
    ryan_mayu
    3 years ago

    Rochejf 

    you can create a new column

    Column = if(CALCULATE(count('Table (2)'[Sales Date]),ALLEXCEPT('Table (2)','Table (2)'[Sales Order]))=CALCULATE(count('Table (2)'[Sales Task]),ALLEXCEPT('Table (2)','Table (2)'[Sales Order])),"Y","N")

MaryAmbrose's avatar
MaryAmbrose
Regular Visitor
3 years ago

First, thank you and potentially anyone else who reads this.  I guess you misunderstood my post.  I'm not looking for a solution.  As I mentioned in my post...I already know how to do this with DAX, my point was that you shouldn't have to.  And if I miss posted in this community then that is my fault.  I was trying to post in the community where Microsoft sees voted on posted to attempt to fix this type of filter need more permanently.  I don't want to use DAX because that means I must create the DAX for every filter that I want to behave this way.  I would rather have Microsoft add it as a permanent filter capability much like Contains, Does Not Contain, Between, etc.  First By Default allows you to set a listed field (e.g. Orders) by default to a numerically or alphabetically first value.  But thank you for trying to help me solve the issue although a code solution is not the type of solution I was hoping for.