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 counts of all values listed in the Column "D".
 
Counts F = COUNTROWS(ALLSELECTED in "NON APPLICABLE","PENDING',"SCHEDULED", "WORKAROUND", "PATCHED" (Col F))-1 
 Not working, 
 
 
 I will show output on graphs. I need to write measure, any help will be appreciated.  Thanks 

 

Help appreciated

7 Replies

  • sdhn's avatar
    sdhn
    Responsive Resident
    4 years ago

    Thanks

    column has created 

    How to display counts in the graph by values ? Total counts of Assesssed & Non Assessed? 

  • 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