Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Please find out the expected file Here ,
For expected output I'm showing the data in different column without blank but I need to show the same data in same column.
Hi @Anonymous
can you please try below measure
I have used below condition.
Proud to be a Super User! | |
Based on above measure blanks are removing but data's are not showing as expect to dataset
Please be find out the expected file Here ,
For the expected output I'm showing the data in different column without blank but I need to show the same data in same column.
Hi, I honestly did not understand what you need. you can show the result and how you applied the ISINSCOPE functions
As shown above image you can see the blanks in hierarchy that blanks I need to remove
User | Count |
---|---|
98 | |
76 | |
75 | |
48 | |
27 |