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
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.
View solution in original post
solo con filtrar la columna de rectangulos sin tomarlos a ellos ya los eliminas,
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.