Forum Discussion

bhalicki's avatar
bhalicki
Icon for Helper V rankHelper V
5 years ago
Solved

ALLNOBLANKROW behaviour

Hi all,   ALLNOBLANKROW isn't giving me the results I expect, i'm trying to understand why... My model is as follows: PROJECT BUDGET   Project and Budget are related by ProjectCode...
DAX
PowerBI Community
  • Fowmy's avatar
    Fowmy
    5 years ago

    bhalicki 

    You can modify your measure as follows. You are applying a filter from the Project table which will eliminate any value that is not available in the project table.

     TotalBudgetNoBlanks = CALCULATE(SUM(Budget[Amount]), Project))

     

  • Fowmy's avatar
    Fowmy
    5 years ago

    bhalicki 

    In your calculation, when you add Description, it adds a filter eventually filtering the values. I added Product as a filter to Calculate the force the only available Project Codes.


    I will direct you to some good resources to understand further:

    https://www.youtube.com/watch?v=GIP5dzBmUxc


Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
5 years ago

bhalicki 

You can modify your measure as follows. You are applying a filter from the Project table which will eliminate any value that is not available in the project table.

 TotalBudgetNoBlanks = CALCULATE(SUM(Budget[Amount]), Project))

 

bhalicki's avatar
bhalicki
Icon for Helper V rankHelper V
5 years ago

Fowmythat does exactly what i'm after, thank you very much!  My only question is, are you able to explain why ALLNOBLANKROW is doing what it is in my scenario above?  Based on documentation and tutorials, seems this is exactly what it is designed to do.

  • Fowmy's avatar
    Fowmy
    Icon for Super User rankSuper User
    5 years ago

    bhalicki 

    In your calculation, when you add Description, it adds a filter eventually filtering the values. I added Product as a filter to Calculate the force the only available Project Codes.


    I will direct you to some good resources to understand further:

    https://www.youtube.com/watch?v=GIP5dzBmUxc