Forum Discussion
Delete subrows data
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
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
2 Replies
solo con filtrar la columna de rectangulos sin tomarlos a ellos ya los eliminas,
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
