Forum Discussion

heiligbd's avatar
heiligbd
Icon for Helper I rankHelper I
2 years ago
Solved

Differentiate Between Blanks and No Data Measure

Good day,   So I have a dataset where as its for on time performance. However, I am having an issue with the current formula regarding differentiating between No data and blank data. Essentially, i...
Need Help
Show and Tell
  • Greg_Deckler's avatar
    Greg_Deckler
    2 years ago

    heiligbd Maybe:

    OD 1d = 
  IF(
      COUNTROWS('ODData') = BLANK(),
      "N/A",
      CALCULATE(
        DIVIDE(
          SUM(ODData[Points < 1d]),
          SUM(ODData[Points > 14d]),
          BLANK()
        ),
        ODData[Reason1stLetter]<>"9"
      )
   )
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
2 years ago

heiligbd Maybe:

OD 1d = 
  IF(
      COUNTROWS('ODData') = BLANK(),
      "N/A",
      CALCULATE(
        DIVIDE(
          SUM(ODData[Points < 1d]),
          SUM(ODData[Points > 14d]),
          BLANK()
        ),
        ODData[Reason1stLetter]<>"9"
      )
   )
heiligbd's avatar
heiligbd
Icon for Helper I rankHelper I
2 years ago

Thanks Greg. This didn't exactly solve it however, I used your idea of COUNTROWS= BLANK() and created a nested IF statement in front of the rest of my equation and that solved this issue. 

 

Thanks again,

 

Bryant