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.
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")
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 |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |