Forum Discussion

sdhn's avatar
sdhn
Responsive Resident
4 years ago
Solved

Condition & Counts

Hi All,   Here are the two columns from my source table "Table A"       1) If Column F = Not Assessed or Blank = Not Assessed If Column F = Yes or No = Assessed   2) I need total co...
Help appreciated
sdhn's avatar
sdhn
Responsive Resident
4 years ago

For number 2, i can get total counts of rows from below:

Counts Status = COUNTROWS(ALLSELECTED('TABLE A'[D]))-1
 
But I want for indiviual values as:

  Please note:

Column values are in sentensec for each rows.

In each sentense either pending , scheduled , patched, workaround & nonapplicable is used. 

  • VahidDM's avatar
    VahidDM
    Super User
    4 years ago

    Hi sdhn 

     

    Can you post sample data as text and expected output?

    please see this post regarding How to Get Your Question Answered Quickly:
    https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

    The most important parts are:
    1. Sample data as text, use the table tool in the editing bar
    2. Expected output from sample data
    3. Explanation in words of how to get from 1. to 2.
    4. Relation between your tables

    Appreciate your Kudos!!
    LinkedIn:www.linkedin.com/in/vahid-dm/

    • sdhn's avatar
      sdhn
      Responsive Resident
      4 years ago
       Column F
       YES
       NO
       NO
       YES
        
        
        
      If Column F = Not Assessed or Blank = Not Assessed
      If Column F = Yes or No = Assessed
      I have my existing code but not getting values as above.

      Your help will be appreciated 

       
      Thats I need it. Thanks 
      • VahidDM's avatar
        VahidDM
        Super User
        4 years ago

        sdhn 

         

        Try this:

        Column =
SWITCH(
    TRUE(),
    [Column F] = "NOT ASSESSED"
        || [Column F] = BLANK(), "NOT ASSESSED",
    [Column F] = "YES"
        || [Column F] = "NO", "ASSESSED"
)

         

        Output:

         

         

         

         

        If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
        Appreciate your Kudos!!
        LinkedIn:         www.linkedin.com/in/vahid-dm/