Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello experts,
is it possible to delete the subrows data? I dont need it twice.
The data which I want to delete, I marked it with a red rectangle.
It is possible to do that in Power BI?
Thanks in advance for your Help
--
azaterol
Solved! Go to Solution.
Hi @azaterol ,
You could create a calculated column as a mark to these subrows and use this mark to filter these data.
mark = if(condition,"sub","not sub")
In the dax formula, you could add a condition to the formula like:
measure = calculate(sum(value),filter(table,mark="sub"))
If I misunderstood your meaning, please show some sample data and expected result to us.
Best Regards,
Jay
Hi @azaterol ,
You could create a calculated column as a mark to these subrows and use this mark to filter these data.
mark = if(condition,"sub","not sub")
In the dax formula, you could add a condition to the formula like:
measure = calculate(sum(value),filter(table,mark="sub"))
If I misunderstood your meaning, please show some sample data and expected result to us.
Best Regards,
Jay
solo con filtrar la columna de rectangulos sin tomarlos a ellos ya los eliminas,
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
91 | |
89 | |
79 | |
69 | |
68 |
User | Count |
---|---|
222 | |
128 | |
117 | |
82 | |
77 |