Forum Discussion

aarikc17's avatar
aarikc17
Advocate I
9 years ago
Solved

Timestamp Nested If

I work in a manufacturing setting.   I am trying to create a dashboard that will tell me how many units I've started that day.   Currently I have created a new column with the following.   VSta...
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi aarikc17,

     

    Based on my understanding, you want to count how many records when [WRK-AREA] is "CLES10000" and [ARRIVAL_TS] equals today, right?

     

    You can create a measure below:

     

    Measure = CALCULATE(COUNTROWS('Query1'),FILTER(ALL(Query1),'Query1'[WRK_AREA]="CLES10000" && 'Query1'[ARRIVAL_TS]=TODAY()))

     

     

    If above doesn't meet your requirement, please clarify which results you want based on the dummy data.

     

    Best Regards,
    Qiuyun Yu

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi aarikc17,

 

Based on my understanding, you want to count how many records when [WRK-AREA] is "CLES10000" and [ARRIVAL_TS] equals today, right?

 

You can create a measure below:

 

Measure = CALCULATE(COUNTROWS('Query1'),FILTER(ALL(Query1),'Query1'[WRK_AREA]="CLES10000" && 'Query1'[ARRIVAL_TS]=TODAY()))

 

 

If above doesn't meet your requirement, please clarify which results you want based on the dummy data.

 

Best Regards,
Qiuyun Yu

  • aarikc17's avatar
    aarikc17
    Advocate I
    9 years ago

    This calculate measure worked yesterday, but today the count is (blank).

     

     

    • aarikc17's avatar
      aarikc17
      Advocate I
      9 years ago

      CountAX seems to be working

      • aarikc17's avatar
        aarikc17
        Advocate I
        9 years ago

        How would you do this with a direct query?