Forum Discussion

freemainia's avatar
freemainia
Icon for Helper I rankHelper I
3 years ago
Solved

COUNTIF measure

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...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    3 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

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")