topic Re: Divide filter in DAX Commands and Tips

Divide filter

Anonymous — Tue, 04 Feb 2020 16:39:29 GMT

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

Re: Divide filter

Anonymous — Tue, 04 Feb 2020 17:22:34 GMT

Divide(
Calculate([measure],filter(table,table[col]="value"),[measure2])

Thanks
Pravin

If it resolves your problem mark it as a solution and give Kudos.

Re: Divide filter

Anonymous — Wed, 05 Feb 2020 08:39:36 GMT

Hi Anonymous ,

Thanks for your reply.

I currently have:

Divide% = Divide(

Calculate([Total Breached],filter(table,table[Key]<>"471"),[Count of Incidents]).

This says too few arguments were passed to the divide function. The minimum is 2?

Thanks in advance

Liam

Re: Divide filter

Anonymous — Wed, 05 Feb 2020 09:00:08 GMT

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

Re: Divide filter

Anonymous — Wed, 05 Feb 2020 09:41:12 GMT

Hi Anonymous ,

Thankyou, it now accepts this.

I have both calculations next to each other in my matrix but the first divide displays all of the % as expected, but the new formula to filter out one of the rows, or display it as 0, displays blank on the whole column. Ive attached an image.

Would you have any idea why it displays like this?

Thanks again for your help with this

Liam

Re: Divide filter

Anonymous — Wed, 05 Feb 2020 10:15:17 GMT

debug your measure.

First check which measure is showing blank in divide and why.

Check is there any value other than 471 also check data type of column. you add 471 in (""). Hence it is taking it as string. 471 only for int.

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

Re: Divide filter

Anonymous — Wed, 05 Feb 2020 11:20:59 GMT

Thanks for your help with this Anonymous . After playing around with the formatting its managed to show up as expected.

Thanks

Liam