Forum Discussion

jibran_wani's avatar
jibran_wani
Regular Visitor
1 year ago
Solved

Need help in All Function

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

 

"DAX " "DAX help" 'Need help'
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.

     

     

3 Replies

  • ThxAlot's avatar
    ThxAlot
    Super User
    1 year ago

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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.

     

     

  • govind_021's avatar
    govind_021
    Super User
    1 year ago

    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