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...
"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.

     

     

ThxAlot's avatar
ThxAlot
Icon for Super User rankSuper 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.