Differentiate Between Blanks and No Data Measure

Question

Good day,&nbsp;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, if there is data and its all blanks, I want the score to be 0%. If there is no data, I want it to read "N/A". How can I change the below measure to account for this? Right now, everything shows "N/A" regardless of if there is no data at all for a given type of material, or if all the data is blank which should read 0%.&nbsp;OD 1d = IF(ISBLANK(CALCULATE(DIVIDE(SUM(ODData[Points &lt; 1d]),SUM(ODData[Points &gt; 14d]),BLANK()),ODData[Reason1stLetter]&lt;&gt;"9")),"N/A",CALCULATE(DIVIDE(SUM(ODData[Points &lt; 1d]),SUM(ODData[Points &gt; 14d]),BLANK()),ODData[Reason1stLetter]&lt;&gt;"9"))&nbsp;The date set has the following:OrderDateOD1Type110/3/23100%A210/4/23&nbsp;A310/4/23100%B410/5/23&nbsp;B&nbsp;&nbsp;This would be no in table data for C typeC&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

greg_deckler · Accepted Answer

heiligbd&nbsp;Maybe:
OD 1d = 
  IF(
      COUNTROWS('ODData') = BLANK(),
      "N/A",
      CALCULATE(
        DIVIDE(
          SUM(ODData[Points &lt; 1d]),
          SUM(ODData[Points &gt; 14d]),
          BLANK()
        ),
        ODData[Reason1stLetter]&lt;&gt;"9"
      )
   )

Forum Discussion

Differentiate Between Blanks and No Data Measure

2 Replies

Related content

Hourly Rate Differential

Measure

Data Differential

DAX Measure

Differentiate operations

Order	Date	OD1	Type
1	10/3/23	100%	A
2	10/4/23		A
3	10/4/23	100%	B
4	10/5/23		B
		This would be no in table data for C type	C