Help me with a tricky DAX situation

[shushank]

Hi All,

I am connected to a cube(SSAS) and trying to write a measure(since I can't add calc column). My scenario is 

I have two column lets say A and B.

Both these columns have blanks and numbers and in a Matrix visual, I am using a subtotal for both the columns.

Now, I don't want to add the number where any column has blank against each other. What I mean to say

if both the columns have values then only add those values rest ignore. 

let me know if more details are required.

Thanks,

S

[OwenAuger]

Hi @shushank 

If I understand you correctly, you want to calculate a measure with a filter applied so that both A & B are nonblank.

Since this condition is the intersection of two nonblank conditions, you could write something like this:

Measure with A and B nonblank =
CALCULATE (
    [Original Measure],
    KEEPFILTERS ( NOT ISBLANK ( YourTable[A] ) ),
    KEEPFILTERS ( NOT ISBLANK ( YourTable[B] ) )
)

I suggest including KEEPFILTERS in order to retain any existing filters on either A or B.

Is this what you're looking for?

Regards,

Owen

[Anonymous]

Measure with A and B nonblank =
CALCULATE (
    [Original Measure],
    Filter(TaBLE,TABLE[col1]<>Blank() && table[Col2]<>Blank)
)

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.

check my blog here
https://community.powerbi.com/t5/Community-Blog/Connecting-to-a-Tabular-Model-Using-Power-BI/ba-p/91...