Returning blank values when picking a date

Question

Hello,Weird thing happening here and I'm almost positive it has to do with a table relationship.I'm using a measure to count items that populate in a table and putting it on a card. Here's what I'm using&nbsp;CALCULATE(COUNT(IPL[Part_Nbr]), IPL[ID] = "P", IPL[Part_Nbr - Copy.1] = "FG")&nbsp;Now, when I do not choose a date from the date filer I get a returned value. But if I choose a fiscal month I get blank.&nbsp;&nbsp;Any help or insight would be appreciated.

lbendlin · Answer

Please show the data model, and where the fiscal quarter field is in the model relative to your data.

datainsights · Answer

Anonymous,&nbsp;Would you be able to provide sample data and a screenshot of your data model?

Forum Discussion

Returning blank values when picking a date

2 Replies

Related content

Measure returning incorrect value

Date Different return wrong value

MAXX Returning duplicate values

Return "Specific value" from table 1, if not found, return value from table 2

Create Measure to Return Highest Value