Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Incorrect Measure Total on Matrix Visual

Hi,   I have the following the following report page with a date slicer and a table.   - The date slicer comes from a date table that DOES NOT have a relationship with my facts table.  -Th...
DAX
matrix
sum
Totals
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi  Anonymous ,

     

    Thanks for the reply from DataNinja777 , please allow me to provide another insight:  

    You can using the following measure.

    Measure =
SUMX(
    VALUES('Fact Table'[ID]),[Calculation])

     

    Best Regards,

    Liu Yang

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

DataNinja777's avatar
DataNinja777
Super User
2 years ago

Hi Anonymous 

You can get the correct total of the rows in the visual by using Sumx function.  Sumxing Calculation dax over the ID field will get you the correct total you are after.