Icon

[dofrancis3]

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:

Yes	No
10	7

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

[Anonymous · Accepted solution]

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

[xifeng_L]

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]

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]

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~

[dofrancis3]

Dear @xifeng_L thank you for your replay but how can i display also 0 in this table?

[dofrancis3]

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.