Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
94 | |
86 | |
78 | |
72 | |
66 |
User | Count |
---|---|
115 | |
106 | |
85 | |
65 | |
64 |