Forum Discussion
Resolver IIcon
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
Super UserHi 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~
Resolver IDear 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