Ignore external filter on dax formula

[FZOU]

Hello ,

I'm trying to calculate the PDM global (market share) , and respresnt it by company, so i want to fix the denomirator in the divide function to not get affected by company column but i didn't find a solution.

This is my formula : 

PDM Global = DIVIDE([Volume N Market],[Volume N Market] ,0)

Any help please ?

[amitchandak · Accepted solution]

@FZOU , need to have more information on formula and tables. But the use of all to ignore filter can help

PDM Global = DIVIDE([Volume N Market],calculate([Volume N Market],all(company)) ,0)

https://www.sqlbi.com/articles/managing-all-functions-in-dax-all-allselected-allnoblankrow-allexcept...

[FZOU]

@amitchandak it work's perfectly,thank you 🙂

[vanessafvg]

pdm global =
var denominator = x
return DIVIDE([Volume N Market],denominator ,0)

[Pragati11]

Hi @FZOU ,

How is your denominator [Volume N Market] getting calculated?

This is a measure that you must be calculating by summarising a column. Can you share tha calculation?

Thanks,

Pragati