topic Re: Replace Blank Values and Empty Visuals in DAX Commands and Tips

Replace Blank Values and Empty Visuals

PhineasT — Mon, 03 Oct 2022 14:44:47 GMT

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?

Re: Replace Blank Values and Empty Visuals

tamerj1 — Mon, 03 Oct 2022 15:02:54 GMT

Hi PhineasT

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

Assuming activities =
"Original aggregation formula" + 0

Re: Replace Blank Values and Empty Visuals

PhineasT — Mon, 03 Oct 2022 15:09:53 GMT

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.

Re: Replace Blank Values and Empty Visuals

tamerj1 — Mon, 03 Oct 2022 15:20:39 GMT

Hi PhineasT

please try this measure

Count =
DISTINCTCOUNT ( ByProjectActivityTbl[ProjectActivity] ) + 0

you try with COUNTA instead of DISTINCTCOUNT depending on your requirement

Re: Replace Blank Values and Empty Visuals

PhineasT — Mon, 03 Oct 2022 16:22:50 GMT

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'.

Re: Replace Blank Values and Empty Visuals

tamerj1 — Mon, 03 Oct 2022 16:28:51 GMT

PhineasT
Please try

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

Re: Replace Blank Values and Empty Visuals

PhineasT — Mon, 03 Oct 2022 16:43:39 GMT

Power BI didn't like it -

Re: Replace Blank Values and Empty Visuals

tamerj1 — Mon, 03 Oct 2022 16:46:23 GMT

PhineasT

Delete this part

Re: Replace Blank Values and Empty Visuals

PhineasT — Mon, 03 Oct 2022 16:51:13 GMT

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

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

Re: Replace Blank Values and Empty Visuals

tamerj1 — Mon, 03 Oct 2022 16:52:35 GMT

PhineasT

Hit "Enter"

Re: Replace Blank Values and Empty Visuals

PhineasT — Mon, 03 Oct 2022 16:55:58 GMT

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?

Re: Replace Blank Values and Empty Visuals

tamerj1 — Mon, 03 Oct 2022 17:10:34 GMT

PhineasT

Yes. Please try

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

Re: Replace Blank Values and Empty Visuals

PhineasT — Mon, 03 Oct 2022 17:20:39 GMT

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.