Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
Hi @Yagevendra ,
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.
Hi @Yagevendra ,
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.
@v-stephen-msft 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.
@Yagevendra To eliminate possibilities of typos and such, perhaps try:
Platform = IF(table[Platform]="Total" || table[Platform]="TotalFB" || table [Platform]="TotalYoutube","Total (18+)",table[Platform])
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
102 | |
84 | |
79 | |
70 |
User | Count |
---|---|
120 | |
110 | |
95 | |
82 | |
77 |