Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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")
Solved! Go to Solution.
Hey @lardo5150 ,
wrap something like this around your working measures:
IF(HASONEVALUE('<tablename>'[Engineer])
, [your measure]
, BLANK()
)
Regards,
Tom
use isfiltered
https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/
Hey @lardo5150 ,
wrap something like this around your working measures:
IF(HASONEVALUE('<tablename>'[Engineer])
, [your measure]
, BLANK()
)
Regards,
Tom
Really close....
It puts the "BLANK" in there.
Is it possible to show a zero?
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
Actually, It was open for sometime with me, and I did not realize that you have already given a solution. Thanks for the explanation.
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])
User | Count |
---|---|
93 | |
85 | |
78 | |
68 | |
63 |
User | Count |
---|---|
113 | |
99 | |
96 | |
64 | |
58 |