topic Re: Need help in All Function in DAX Commands and Tips

Need help in All Function

jibran_wani — Wed, 11 Dec 2024 11:58:54 GMT

Hi All,

I am getting blank dimension value automatically when i use ALL function. Can anyone please help?
I do not want this blank getting assigned in 'Total Sales'.

Total Sales= CALCULATE([Net Sales],ALL('Pro'))

'Division' is coming from 'Pro' . Note that I want to use an attribute parameter in this table with all columns coming from 'Pro' like Division, Setup, etc.

Can anyone please help?

Desired Result -

Thank you

Re: Need help in All Function

ThxAlot — Wed, 11 Dec 2024 12:33:37 GMT

Typical result of Referential Integrity Violation of your data model, nothing to do with ALL(). Google that term if you want to learn a bit more.

Re: Need help in All Function

Anonymous — Thu, 12 Dec 2024 03:19:30 GMT

Hi jibran_wani ,

Based on the information you provided, these table columns must not be from the same table. Refer to below table relationship and formula:

Total Sales = CALCULATE(SUM(Pro[Net Sales]), ALL('Pro'))

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Need help in All Function

govind_021 — Thu, 12 Dec 2024 04:52:57 GMT

Hey ,
select your visual and open filter pane
go to filter on this visual and for Division , select basic filtering and selcet all division except "Blank"
Thank You