Forum Discussion

dofrancis3's avatar
dofrancis3
Resolver I
1 year ago
Solved

Icon

Dear Colleagues;

 

I reach out to you to request your support

1. I have the data set below:

Did you receive your salary?
Yes
Yes
Yes
No
Yes
No
No
No
Yes
Yes
No
No
No
Yes
Yes
Yes
Yes

 

2. this the results of countif:

YesNo
107

 

3. But instead of this kind of results "i would like to have the results below Highlight in green" :

 

 

 

 

 

  • Anonymous's avatar
    Anonymous
    1 year ago

    Thanks for the reply from xifeng_L , please allow me to provide another insight: 
    Hi  dofrancis3 ,

     

    Here are the steps you can follow：

    1. Create calculated table.

    Table 2 =
var _table=
SUMMARIZE(
    'Table',[Did you receive your salary?],"Count",COUNTX('Table',[Did you receive your salary?]))
var _yes=
SUMX(FILTER(_table,[Did you receive your salary?]="Yes"),[Count])
VAR _NO=
SUMX(FILTER(_table,[Did you receive your salary?]="No"),[Count])
VAR _table2=
SELECTCOLUMNS(
_table ,
    "Yes",IF(_yes>=_NO,1,0),
    "No",IF(_NO>_yes,1,0))
return
DISTINCT(
    _table2)

    2. Result:

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

6 Replies

  • dofrancis3's avatar
    dofrancis3
    Resolver I
    1 year ago

    Or is there another way to get the same results that can allow me to use the Icon? because i would like to use ICON instead of number.

     

  • xifeng_L's avatar
    xifeng_L
    Super User
    1 year ago

    Hi dofrancis3

     

    You can try the svg to generate the icon, such as:

     

     

     

    Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

     

    Thank you~

    • dofrancis3's avatar
      dofrancis3
      Resolver I
      1 year ago

      Dear xifeng_L From my on of the colomns that i have i my data set I would like : from this colomn (Dit you receive your salary) to get table Highlight in yellow below.

       

      • xifeng_L's avatar
        xifeng_L
        Super User
        1 year ago

        You can try below calculated table expression.

         

         

        Table 2 = 
SELECTCOLUMNS(
    SUMMARIZECOLUMNS('Table'[Did you receive your salary?],"Salary",COUNTROWS('Table')),
    "Salary",IF('Table'[Did you receive your salary?]="Yes",[Salary],0)
)

         

         

        Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

         

        Thank you~

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Thanks for the reply from xifeng_L , please allow me to provide another insight: 
    Hi  dofrancis3 ,

     

    Here are the steps you can follow：

    1. Create calculated table.

    Table 2 =
var _table=
SUMMARIZE(
    'Table',[Did you receive your salary?],"Count",COUNTX('Table',[Did you receive your salary?]))
var _yes=
SUMX(FILTER(_table,[Did you receive your salary?]="Yes"),[Count])
VAR _NO=
SUMX(FILTER(_table,[Did you receive your salary?]="No"),[Count])
VAR _table2=
SELECTCOLUMNS(
_table ,
    "Yes",IF(_yes>=_NO,1,0),
    "No",IF(_NO>_yes,1,0))
return
DISTINCT(
    _table2)

    2. Result:

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly