Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Same string showing double time in filter.

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(t...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
4 years ago

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])