Forum Discussion
Solved
New Column with Blank value Count
Hello there, I have created a new table and added few column as seen in picture below. I've also added a new column says "Counts"(DAX can be seen in picture). Currently it does count blank value...
Hi hello_MTC ,
You can update the formula of your calculated column [Counts] as below and check if it can return the correct result... Please find the details in the attachment.
Counts = VAR _count = CALCULATE ( COUNT ( 'CountTable'[Incident_id] ), FILTER ( 'CountTable', 'CountTable'[Incident_id] = EARLIER ( 'CountTable'[Incident_id] ) ) ) RETURN IF ( ISBLANK ( _count ), BLANK (), IF ( _count <= 9, FORMAT ( _count, "General Number" ), "10+" ) )Best Regards
Hi hello_MTC ,
Just update the formula of calculated column [Counts ]as below:
Counts =VAR _count =CALCULATE (COUNT ( 'CountTable'[User_id] ),FILTER ('CountTable','CountTable'[Incident_id] = EARLIER ( 'CountTable'[Incident_id] )))RETURNIF (ISBLANK ( 'CountTable'[User_id] ),0,IF ( _count <= 9, FORMAT ( _count, "General Number" ), "10+" ))Best Regards
Hi, You're awesome. But, I mistakenly mentioned that I need blank if user_id is blank. Actually I need 0 if user_is has balnk cell values.
I am sorry for the inconvinience!
Hi hello_MTC ,
Just update the formula of calculated column [Counts ]as below:
|
Counts =
VAR _count =
CALCULATE (
COUNT ( 'CountTable'[User_id] ),
FILTER (
'CountTable',
'CountTable'[Incident_id] = EARLIER ( 'CountTable'[Incident_id] )
)
)
RETURN
IF (
ISBLANK ( 'CountTable'[User_id] ),
0,
IF ( _count <= 9, FORMAT ( _count, "General Number" ), "10+" )
)
|
Best Regards
Awesome, I put the 0 in quotation mark and it worked. Thank you so much.