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
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/

     

     

    • sdhn's avatar
      sdhn
      Responsive Resident
      4 years ago

      I need to dispaly in the graph.

      Table is exsited.  Thanks