Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
VStart = IF(Query1[WRK_AREA]="CLES10000",IF(DAY(Query1[ARRIVAL_TS])=TODAY(),"True","False"),"False")
A started unit counts when it reaches the WRK-AREA "CLES10000".
I have validated that the data I want to retrieve is in my data set.
Any advice/help?
Solved! Go to Solution.
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
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
This calculate measure worked yesterday, but today the count is (blank).
CountAX seems to be working
How would you do this with a direct query?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |