Show Zero Count unless selected in a slicer

[lardo5150]

I currently have this setup.

I want to choose a date range

select an engineer

and it will show me the total number of critsits, normal, hot cases they took.

I have measure setup for each of the values from that column

For example, to get the count of "normal" 

CALCULATE(COUNT('Acceptance History'[CRITSIT])+0,ALLSELECTED('Acceptance History'[Engineer]),'Acceptance History'[CRITSIT]="Normal")

This works, but if I have no engineer elected, it still shows me the total number taken between all the engineers for that specific date range.

I want it to show zero UNTIL I select an engineer.

History'[Engineer]),'Acceptance History'[CRITSIT]="Normal")

[amitchandak]

use isfiltered

https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/

[TomMartens · Accepted solution]

Hey @lardo5150 ,

wrap something like this around your working measures:

IF(HASONEVALUE('<tablename>'[Engineer])
, [your measure]
, BLANK()
)

Regards,

Tom

[lardo5150]

Really close....

It puts the "BLANK" in there.

Is it possible to show a zero?

[TomMartens]

Hey @lardo5150 ,

just replace the formula BLANK() with 0

Hey @amitchandak , there is a tiny difference between ISFILTERED and HASONEVALUE, for this reason, I would not generally replace HASONEVALUE with ISFILTERED.

Regards,

Tom

[amitchandak]

@TomMartens 

Actually, It was open for sometime with me, and I did not realize that you have already given a solution. Thanks for the explanation.

[lardo5150]

I actually combined what he first gave me, with something I found in another post.

This worked for me.

IF(HASONEVALUE('<tablename>'[Engineer])
, [your measure]
, BLANK()
)

then combined it with this:

if(ISBLANK([Original Measure]),0,[Original Measure])