change in measure

[Anonymous]

hello,

I have created a mesaure like this,

CALCULATE(CALCULATE(sum('Table AOP'[Value]),ALL('Table AOP'[Description])),KEEPFILTERS('Table AOP'[Scenario]=="Actual"),ALLNOBLANKROW('Table AOP'[Description]))

the column description contains some blank values, i need to ignore that, but its not working with above dax. its adding the values from column value of that description column for blanks too.

I have tried passing filter to remove blank but it not working with the above result.

What changes do I need to make in dax?

[Anonymous]

Hi @Anonymous ,

Has the problem be solved?

Can you show some sample data and expected result to us?

Best Regards,

Jay

[Anonymous]

I have used the below measure,

TotalActual = CALCULATE(sum('Table AOP'[Value]),FILTER(ALLNOBLANKROW('Table AOP'[Description]),NOT('Table AOP'[Description]=BLANK())),KEEPFILTERS('Table AOP'[Scenario]=="Actual"))

And that removes the blank rows from description column to get the result at the end.

[Anonymous]

I'm showing you the measure... but you definitely should read/watch the materials I posted just minutes ago. If you don't do it, you'll not know what's going on and why your DAX above does not do what you think it should. Up to you.

[Measure] =
    CALCULATE(
        SUM( 'Table AOP'[Value] ),
        KEEPFILTERS( 'Table AOP'[Scenario] = "Actual" ),
        KEEPFILTERS(
            NOT( ISBLANK( 'Table AOP'[Description] ) )
        )
    )
    
// With new syntax... it should
// work if you've got the latest
// PBI.
[Measure] =
    CALCULATE(
        SUM( 'Table AOP'[Value] ),
        KEEPFILTERS(
            'Table AOP'[Scenario] = "Actual" 
            &&
            NOT( ISBLANK( 'Table AOP'[Description] ) )
        )
    )

[Anonymous · Accepted solution]

Thanks. Unfortunately result is not coming with the above solution but the material you provided that helped to bring the result 😊

[Anonymous]

@Anonymous 

If you go to ALLNOBLANKROW – DAX Guide and read it carefully, you'll know why it doesn't work. But to understand it, please watch this: Blank row in DAX - YouTube