Forum Discussion

PhineasT's avatar
PhineasT
Icon for Helper I rankHelper I
3 years ago
Solved

Replace Blank Values and Empty Visuals

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's avatar
    tamerj1
    3 years ago

    Hi PhineasT 

    please try this measure 

    Count =
    DISTINCTCOUNT ( ByProjectActivityTbl[ProjectActivity] ) + 0

     

    you try with COUNTA instead of DISTINCTCOUNT depending on your requirement 

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi PhineasT 

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

Assuming activities =
"Original aggregation formula" + 0

  • PhineasT's avatar
    PhineasT
    Icon for Helper I rankHelper I
    3 years ago

    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's avatar
      tamerj1
      Icon for Community Champion rankCommunity Champion
      3 years ago

      Hi PhineasT 

      please try this measure 

      Count =
      DISTINCTCOUNT ( ByProjectActivityTbl[ProjectActivity] ) + 0

       

      you try with COUNTA instead of DISTINCTCOUNT depending on your requirement 

      • PhineasT's avatar
        PhineasT
        Icon for Helper I rankHelper I
        3 years ago

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