Forum Discussion

sharvan029's avatar
sharvan029
Regular Visitor
9 years ago
Solved

How can i use the CALCULATE function to get the Total?

Hi, I am trying find out the Total Sale of Movie ticket  of all the Movies , as you can see in the screenshot I have created a measure like CAL Total Sale_AllMovie = CALCULATE([Sum of tota...
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    9 years ago

    Hi sharvan029

     

    Remove filters from MovieGenre as well. Revised code

    CAL Total Sale_AllMovie =
CALCULATE (
    [Sum of total sales],
    ALL ( MovieDetails[Movietitle] ),
    ALL ( MovieDetails[MovieGenre] )
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
9 years ago

Hi sharvan029

 

Remove filters from MovieGenre as well. Revised code

CAL Total Sale_AllMovie =
CALCULATE (
    [Sum of total sales],
    ALL ( MovieDetails[Movietitle] ),
    ALL ( MovieDetails[MovieGenre] )
)