Forum Discussion
Divide filter
Hi,
I have a calculation of dividing a measure by a measure:
Total Breached % =
DIVIDE([Total Breached],[Count of Incidents]) + 0
I want to exclude a certain value that is attached to certain rows of data. What would the dax formula be for the divide but filter on the value?
Thanks
Liam
You have not closed bracket of calculate.
Try this
Divide% = Divide(Calculate([Total Breached],filter(table,table[Key]<>"471")),[Count of Incidents])Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar
If I resolve your problem Mark it as a solution and give kudos.check my blog here
https://community.powerbi.com/t5/Community-Blog/Connecting-to-a-Tabular-Model-Using-Power-BI/ba-p/913784
6 Replies
You have not closed bracket of calculate.
Try this
Divide% = Divide(Calculate([Total Breached],filter(table,table[Key]<>"471")),[Count of Incidents])Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar
If I resolve your problem Mark it as a solution and give kudos.check my blog here
https://community.powerbi.com/t5/Community-Blog/Connecting-to-a-Tabular-Model-Using-Power-BI/ba-p/913784