Replace Blank Values and Empty Visuals

[PhineasT]

I want to display a '0' in the top box (circle that reads "Blank"), if the is no associated data to calculate and the phrase 'No data available' in the low box (circle).

Is this possible?

[tamerj1 · Accepted solution]

Hi @PhineasT 

please try this measure 

Count =
DISTINCTCOUNT ( ByProjectActivityTbl[ProjectActivity] ) + 0

you try with COUNTA instead of DISTINCTCOUNT depending on your requirement 

[tamerj1]

Hi @PhineasT 

Assuming activities completed is a measure of decimal or integer data type then try

Assuming activities =
"Original aggregation formula" + 0

[PhineasT]

It is not a measure of decimal, it is a text field on which I need to apply a Count condition that returns the total number of 'Activities'.

 I believe the calculationis being impacted by the Project Name dropdown on the right edge. The Activities count changes whent he dropdown changes, and where there is no 'Activity' (Blank) appears.

I think I may need two control, for I need one static control that shows ALL 'Activities' and I need to know how many 'Activities' based on the choice in the dropdown.

[tamerj1 · Accepted solution]

Hi @PhineasT 

please try this measure 

Count =
DISTINCTCOUNT ( ByProjectActivityTbl[ProjectActivity] ) + 0

you try with COUNTA instead of DISTINCTCOUNT depending on your requirement 

[PhineasT]

Is there anything I can do about default text in blank box under each count?

I count is zero I'd like box to default 'No Items Available'.

[tamerj1]

@PhineasT 
Please try

Count =
COALESCE ( DISTINCTCOUNT ( ByProjectActivityTbl[ProjectActivity] ), "No Items Available" )

[PhineasT]

Power BI didn't like it -

[tamerj1]

@PhineasT 

Delete this part

 

[PhineasT]

I intrepreted your instruction to mean delete the 'Count'?

If that is the case Power BI still doesn't like it.

[tamerj1 · Accepted solution]

@PhineasT 

Hit "Enter"

[PhineasT]

I believe this would be still considered part of the original question...

Is it possible to create a Card with a total count that is not impacted by the action of the dropdown, as is the case with all the others?

[tamerj1]

@PhineasT 

Yes. Please try

CALCULATE ( DISTINCTCOUNT ( ByProjectActivityTbl[ProjectActivity] ), REMOVEFILTERS ( ) )

[PhineasT]

I did a few more tests on the 'No items...' change.

Now a number appears when there is content to display rather than the text that was there. Please advise.

The new measure causing this was

Required output is available content, if no available content then 'No items...' message.

This is how it use to look.