Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Forum,
I am here again to ask help,
Now i have a table with columns like below:
PartNo | Step | Status |
AAA | Step1 | In time |
AAA | Step1 | Delay |
AAA | Step2 | Completed |
BBB | Step1 | In time |
BBB | Step1 | Completed |
And i want to count the number of "Delay" and "In time" per PartNo and per Step. But the difficuly is i want: if status for the same PartNo and the same Step contain "Delay", then just count "1" for Delay, and if status for the same PartNo and the same Step contain "Completed" or "In time", then count "1" for In time.
For example, for the table i have here, the result of count will be:
PartNo | Step | Count_Delay | Count_InTime |
AAA | Step1 | 1 | |
AAA | Step2 | 1 | |
BBB | Step1 | 1 | |
I try to use the Measure solution below, but it doesn't work well. And i don't understand why.
I create a measure to return one Status per part
StatusPerPart =
var calc=CALCULATE(DISTINCTCOUNT('Table 2'[PartNo]);
filter('Table 2';
'Table 2'[Status]="Delay"))
Return
If(calc=1;"Delay";"In time")
After, i create a new measure to count the Status,
Count_InTime = countrows(filter(Table 2;Table 2[StatusPerPart]="In time"))
Count_Delay = countrows(filter(Table 2;Table 2[StatusPerPart]="Delay"))
Thank you!
[# In Time] =
CALCULATE(
COUNTROWS( T ),
KEEPFILTERS( T[Status] = "in time" )
)
[# Delay] =
CALCULATE(
COUNTROWS( T ),
KEEPFILTERS( T[Status] = "delay" )
)
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 |
---|---|
54 | |
27 | |
23 | |
14 | |
11 |
User | Count |
---|---|
77 | |
63 | |
44 | |
17 | |
12 |