Forum Discussion
How to build this check?
So I am trying to build a quality report. I'm importing a set of sharepoint data with colums that have one the following values: OK NOK DNA (doesn't apply) So what I want my created colmun to d...
AilleryO
Memorable Member
Memorable MemberHi,
Not sure about what you mean by check, but at least for the count it will be something like :
Create a measure
Count of OK = CALCULATE ( COUNT( [YourColumn] ) , ALL( [YourColumn] ) , [YourColumn]="OK" )
Count of NOK = CALCULATE ( COUNT( [YourColumn] ) , ALL( [YourColumn] ) , [YourColumn]="NOK" )
Count of NOK + OK = CALCULATE ( COUNT( [YourColumn] ) , ALL( [YourColumn] ) , [YourColumn]<>"DNA" )
The ALL( [YourColumn] ) is to remove the filter from the table so I assumed you'll dispaly the measure in a table with [YourColumn] placed on lines If not adjust the ALL according to the filter you need to remove.
Tell us if it works