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.

     

     

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