Forum Discussion

PhineasT's avatar
PhineasT
Helper 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 

12 Replies

  • tamerj1's avatar
    tamerj1
    Community 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
      Helper 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
        Community 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