Same string showing double time in filter.

[Anonymous]

Hi All,
I am facing one problem in Power BI Desktop I created a calculated column and my code which I have written to create a column is:-

Platform = IF(table[Platform]="Total","Total (18+)",IF(table[Platform]="TotalFB","Total (18+)",IF(table [Platform]="TotalYoutube","Total (18+)",table[Platform])))

When I put newly created column in filter it shows me double “Total (18+)” just like below image:                  

And when I tries to click only single total it automatic select both total.

I double check my code and data dropdown shown me only single Total (18+).

Need help to resolve this issue.

[Anonymous · Accepted solution]

Hi @Anonymous ,

Is your problem solved? I tested it with your formula and it was successful, showing single ‘‘Total (18+)’’ in the slicer.

Best Regards,

Stephen Tao

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

[Anonymous]

@Anonymous Thanks for your reply.
Yes, My problem resolved, I don't know what was the problem.
I simple removed calculated column and re created it with the same formula.

[Greg_Deckler]

@Anonymous To eliminate possibilities of typos and such, perhaps try:

Platform = IF(table[Platform]="Total" || table[Platform]="TotalFB" || table [Platform]="TotalYoutube","Total (18+)",table[Platform])