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.
Hi,
I would like to:
1. Count the number of IDs that have a "Yes" in any of the corresponding Train cells (answer = 2)
2. Count the number of IDs that don't have a "Yes", but do have a "Partial", in any of the corresponding Train cells (answer = 2)
3. Count the number of IDs that have a "No" in all of the corresponding Train cells (answer = 1)
Project 1 | Project 2 | Project 3 | What I want | ||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|
|
I would like this to be a measure (rather than a column) as sometimes I may filter to one project, two projects, or all three projects.
Cheers.
Solved! Go to Solution.
Hi,
You may download my PBI file from here.
Hope this helps.
Hi,
Do you have each Project's data in a seperat table?
Currently, they are in separate tables.
Hi,
You may download my PBI file from here.
Hope this helps.
Many thanks @Ashish_Mathur.
Seems to be working now, with the slight adjustment of changing:
to
You are welcome.
@freemainia , For the last columns in the power query a new column
Make sure the two header are merged in date
let
_a = {[Project 1 Train], [Project 2 Train],[Project 3 Train]}
_b = if List.Contains(_a, "Yes") then "Yes" else if List.Contains(_a, "Partial") "Partial" else "No"
in
_b
Or New column in dax
var _a = {[Project 1 Train], [Project 2 Train],[Project 3 Train]}
_b = Switch(true(),
Containsstring(_a, "Yes") , "Yes",
Containsstring(_a, "Partial") , "Partial" ,
"No")
User | Count |
---|---|
89 | |
88 | |
75 | |
67 | |
58 |
User | Count |
---|---|
137 | |
110 | |
92 | |
84 | |
69 |