Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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])
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
94 | |
74 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |