Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Sub total Not working

Hii Everyone,   Can someone please help me to fix this Total.   Refer attached PBI file.   https://easyupload.io/vk2uer         Thank you.
  • v-robertq-msft's avatar
    v-robertq-msft
    4 years ago

    Hi, 

    According to your description, I can roughly understand your requirement, you are facing the error of subtotal not correct in the matrix, right? I think you can try to create a new measure like this:

    Total Man Hours111 =

var _summarize=SUMMARIZE('ProductionLinesTasks',[Order_Number],[IndexKey],"1",[Total Man Hours])

var _sum=SUMX(FILTER(_summarize,[Order_Number]=MAX('ProductionLinesTasks'[Order_Number])),[1])

return

IF(ISINSCOPE('ProductionLinesTasks'[Order_Number])&&NOT(ISINSCOPE(ProductionLinesTasks[IndexKey])),_sum,[Total Man Hours])

     

    And you can go to the original matrix to place this measure to check the subtotal, you can find it displays correctly:

     

    You can download my test pbix file below

    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.