Blank() in Card Visual with another condition

[Applicable88]

Hello,

I'm using following measure to sum the InOut under the condition to filter the card visual only when I selected a stockmaterial and also replaced the typical blank when nothing is selected with "Please select stockmaterial":

IF ( ISFILTERED([Stockmaterial]), SUM([InOut]), "Please select stockmaterial")

Stockmaterial		Index		InOut
a		i		1000
aa		o		-1000
bb		i		800
bb		o		-750
c		i		32
d		i		4234
d		i		757
e		i		234
e		i		234
a		o		-683
a		o		-962

I have three card visuals:

1.Shows only the "inbounds" with index i 

2.Shows only the "outbounds" with index o

3. Shows overall balance of selected stockmaterial. 

What I want to archieve is that when I select a stockmaterial with no outbound yet that the outbound cardvisual always show blank() instead of "0". 

IF ( ISFILTERED([Stockmaterial]), SUM([InOut]), if(isfiltered([Stockmaterial]) && isblank(SUM[InOut]), 0, "Please select stockmaterial"))

I also tried with  ....&& sum([InOut])=0...

The syntax is ok but the card visuals are returning errors. 

Thank you very much in advance. 

Best. 

[PhilipTreacy · Accepted solution]

Hi @Applicable88 

Download example PBIX file with the following code and visuals.

I'm not sure if you are asking to show 0 or BLANK() in trhe card visuals.  Either way, it's easy to change.

Using these 3 measures

Sum InOut = IF ( ISFILTERED('DataTable'[Stockmaterial]), CALCULATE(SUM('DataTable'[InOut]), FILTER(ALL('DataTable'), 'DataTable'[Stockmaterial] = SELECTEDVALUE('DataTable'[Stockmaterial]))), "Please select stockmaterial")

Sum Ins = CALCULATE(SUM('DataTable'[InOut]), FILTER(ALL('DataTable'), 'DataTable'[index] = "i" && 'DataTable'[Stockmaterial]= SELECTEDVALUE('DataTable'[Stockmaterial]))) + 0

Sum Outs = CALCULATE(SUM('DataTable'[InOut]), FILTER(ALL('DataTable'), 'DataTable'[index] = "o" && 'DataTable'[Stockmaterial]= SELECTEDVALUE('DataTable'[Stockmaterial]))) + 0

Will give you the desired outputs in your cards

If you want the Sum In and Sum Out cards to show BLANK() rather than 0, remove the + 0 from the end fo each measure, e.g.

Sum Outs = CALCULATE(SUM('DataTable'[InOut]), FILTER(ALL('DataTable'), 'DataTable'[index] = "o" && 'DataTable'[Stockmaterial]= SELECTEDVALUE('DataTable'[Stockmaterial])))

Regards

Phil

[v-xiaotang · Accepted solution]

Hi @Applicable88 

"What I want to archieve is that when I select a stockmaterial with no outbound yet that the outbound cardvisual always show blank() instead of "0". "

You can try this measure

Measure = 
    var _value=CALCULATE(SUM('Table'[InOut]),FILTER(ALLEXCEPT('Table','Table'[Stockmaterial]),'Table'[InOut]<0))
return 
    IF(ISFILTERED('Table'[Stockmaterial]),IF(ISBLANK(_value),BLANK(),_value),"Please select stockmaterial")

Best Regards,

Community Support Team _Tang

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

[Applicable88]

Thank you @v-xiaotang !

[PhilipTreacy · Accepted solution]

Hi @Applicable88 

Download example PBIX file with the following code and visuals.

I'm not sure if you are asking to show 0 or BLANK() in trhe card visuals.  Either way, it's easy to change.

Using these 3 measures

Sum InOut = IF ( ISFILTERED('DataTable'[Stockmaterial]), CALCULATE(SUM('DataTable'[InOut]), FILTER(ALL('DataTable'), 'DataTable'[Stockmaterial] = SELECTEDVALUE('DataTable'[Stockmaterial]))), "Please select stockmaterial")

Sum Ins = CALCULATE(SUM('DataTable'[InOut]), FILTER(ALL('DataTable'), 'DataTable'[index] = "i" && 'DataTable'[Stockmaterial]= SELECTEDVALUE('DataTable'[Stockmaterial]))) + 0

Sum Outs = CALCULATE(SUM('DataTable'[InOut]), FILTER(ALL('DataTable'), 'DataTable'[index] = "o" && 'DataTable'[Stockmaterial]= SELECTEDVALUE('DataTable'[Stockmaterial]))) + 0

Will give you the desired outputs in your cards

If you want the Sum In and Sum Out cards to show BLANK() rather than 0, remove the + 0 from the end fo each measure, e.g.

Sum Outs = CALCULATE(SUM('DataTable'[InOut]), FILTER(ALL('DataTable'), 'DataTable'[index] = "o" && 'DataTable'[Stockmaterial]= SELECTEDVALUE('DataTable'[Stockmaterial])))

Regards

Phil

[Applicable88]

Thank you @PhilipTreacy !