Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Total not showing correct value in Matrix Table

Hi Experts

 

My cumulative measure works just fine, but the total values in my Matrix Table are not adding up but giving the first row values for each currency type. See image below.

 

My measure for cumulative is

Number of units Sold running total in Created_Hour =
CALCULATE(
    [Number of units Sold],
    FILTER(
        ALLSELECTED('FACTSalesOrderTable'[Created_Hour]),
        ISONORAFTER('FACTSalesOrderTable'[Created_Hour], MIN('FACTSalesOrderTable'[Created_Hour]), DESC)
    )
)

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    Anonymous , Try with max

     

    Number of units Sold running total in Created_Hour =
    CALCULATE(
    [Number of units Sold],
    FILTER(
    ALLSELECTED('FACTSalesOrderTable'[Created_Hour]),
    ISONORAFTER('FACTSalesOrderTable'[Created_Hour], MAx('FACTSalesOrderTable'[Created_Hour]), DESC)
    )
    )

  • v-robertq-msft's avatar
    v-robertq-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi, Anonymous 

    To deal with the problems that the total of measures display incorrectly in the matrix, we usually use this method to create another measure to replace the original measure in the matrix.

    For example, for the measure [APP], you can create a new measure like this:

    APP_new =

var _new=SUMMARIZE('Table','Table'[Qty Sold Hourly],"_value",[APP])

return IF(HASONEVALUE('Table'[Qty Sold Hourly]),[APP],SUMX(_new,[_value]))

     

    And you can go to the matrix to replace the original measure with this one.

    Refer to these links:

    https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

    https://community.powerbi.com/t5/Desktop/How-to-show-total-row-as-sum-of-distinct-count/td-p/1416468

     

    If this method can’t work, you can post your sample pbix file so that we can help you in advance.

    How to Get Your Question Answered Quickly 

    Thank you very much!

     

    Best Regards,

    Community Support Team _Robert Qin

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