Forum Discussion

JD09's avatar
JD09
Advocate I
2 years ago
Solved

Overall Total Mismatch in Table Visual

Hello, Need help in solving the below problem definition: A Power BI Measure needs to Fetch The Latest Product Quantity for the Selected Date & Product (Currently Measure Fetches the Latest Product...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi JD09 

    You can create  a new measure.

     

    Total =
    SUMX ( VALUES ( 'Table'[Product Name] ), [Measure] )

     

     the [product name] field need to make sure is the field that you put to the table visual.

     

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.