Need help in All Function

[jibran_wani]

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

[govind_021]

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

[Anonymous · Accepted solution]

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.

[ThxAlot]

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.