cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DschroyenBruss
New Member

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 do is:

  1. Check the selected colmuns
  2. Count the number of OK and NOK (ignore the doesn't applies)
  3. Produces a % that represents the % of OK's compared to the OK's and NOK's (so "count OK" / ("count OK+ count NOK) )

My main issue being that I only have expercience writting things like this in Excel. My employer is looking into providing me with a Power BI training but it's going to take sometime before I'm in that training.... Patience is not my virtue.... Can anyone provide me with a good tutorial to writing this kind of code in power bi query? 

1 REPLY 1
AilleryO
Super User
Super User

Hi,

 

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

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.