Delete subrows data

[azaterol]

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

[v-jayw-msft · Accepted 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

[Seudopeluche]

solo con filtrar la columna de rectangulos sin tomarlos a ellos ya los eliminas,