Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have a table with the following columns
Case#, Utilities, UtilityStatus
Each Case# has 4 utilites, let's call them A,B, C and D. Each utilities has the following status depending on current situation: complete and pending.
I want to have a measure that returns Complete if all 4 utilities are 'Complete' and Partial otherwise for each Case#
For illustration purposes:
Case# Utilities UtilityStatus
1111 A Complete
1111 B Complete
1111 C Complete
1111 D Complete
2222 A Complete
2222 B Complete
2222 C Pending
2222 D Complete
I want the measure to return Complete for 1111 & Partial for 2222
Solved! Go to Solution.
@Anonymous , Try like
Measure =
var _table = summarize(Table, Table[Case#], "_1", Count(Table[Utilities]) , "_2", countx(filter(Table, Table[UtilityStatus] ="Complete"),Table[Utilities]))
return
maxx(_table, if([_1] =[_2], "Complete", "Partial"))
or
Measure =
var _table = summarize(Table, Table[Case#], "_1", Count(Table[Utilities]) , "_2", countx(filter(Table, Table[UtilityStatus] ="Complete"),Table[Utilities]))
return
calculate( maxx(_table, if([_1] =[_2], "Complete", "Partial")), allexcept(Table, Table[Case#]))
@Anonymous , Try like
Measure =
var _table = summarize(Table, Table[Case#], "_1", Count(Table[Utilities]) , "_2", countx(filter(Table, Table[UtilityStatus] ="Complete"),Table[Utilities]))
return
maxx(_table, if([_1] =[_2], "Complete", "Partial"))
or
Measure =
var _table = summarize(Table, Table[Case#], "_1", Count(Table[Utilities]) , "_2", countx(filter(Table, Table[UtilityStatus] ="Complete"),Table[Utilities]))
return
calculate( maxx(_table, if([_1] =[_2], "Complete", "Partial")), allexcept(Table, Table[Case#]))
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
72 | |
35 | |
21 | |
18 | |
15 |
User | Count |
---|---|
127 | |
31 | |
27 | |
24 | |
22 |