Get the values total into the subtotals and for Grand total In matrix table?

[Pavan_123456789]

(RFID = Segment column
RFID Embaded tags =Category Column)
FSc715-1286 This is item pac item code if the [check month wise] is equal to N Or D Need to get the zero in [First Month After Remove Check Sub Dup] Total as well as sub total and in values .If [check month wise] = Blank() only need to get the value in the value as well as subtotals and Totals{

Check Month Wise = IF(ISBLANK([First Month Qty]),"D",IF(ISBLANK([Sec Month QTY]),"N",BLANK()))}

For this I have created [First Month after remove Check Not sub Dup]=IF([Check Month Wise]=BLANK(),[First Month Qty],0)
Then i have create 

First Month After Remove Check Sub Dup =

CALCULATE(SUMX( VALUES('Financial Data Month'[pac Item Code]) , [First Month after remove Check Not sub Dup])))
Its working but top subtotal is not working 

Or  Finally I need to filterout the data from First Month Qty If Check Month wise  = N or D 
@parry2k

[123abc]

Here's an approach you can take:

1. Modify the "First Month After Remove Check Sub Dup" Measure: Update your measure to consider both conditions when calculating the value. It seems you want to display the value only when "Check Month Wise" is blank. Modify your measure as follows:

First Month After Remove Check Sub Dup =
IF([Check Month Wise] = BLANK(), [First Month Qty], 0)

Adjust the Subtotal Calculation: Ensure that your subtotal calculation is taking into account the condition as well. If you're using a measure for the subtotal, make sure it also considers the "Check Month Wise" condition. For example:

First Month After Remove Check Sub Dup Subtotal =
CALCULATE(
SUMX(VALUES('Financial Data Month'[pac Item Code]), [First Month After Remove Check Sub Dup]),
ALLEXCEPT('YourTable', 'Financial Data Month'[Segment], 'Financial Data Month'[Category])
)

1. The ALLEXCEPT function is used to remove all filters except the ones related to 'Segment' and 'Category'.

2. Handle Grand Total: Similar to the subtotal, ensure that your grand total calculation considers the conditions. You may need to modify the grand total measure to account for the specific conditions:

First Month After Remove Check Sub Dup Grand Total =
CALCULATE(
SUMX(VALUES('Financial Data Month'[pac Item Code]), [First Month After Remove Check Sub Dup])
)

Filtering Data: If you want to filter out data where "Check Month Wise" is 'N' or 'D', you can adjust your visual level filter or use a measure to filter the data. For example:

Filtered First Month Qty =
CALCULATE(
[First Month Qty],
'YourTable'[Check Month Wise] <> "N" && 'YourTable'[Check Month Wise] <> "D"
)

1. Then, use this measure in your visuals instead of the original "First Month Qty."

Remember to replace 'YourTable' with the actual name of your table. Adjust the measures accordingly based on your data model and requirements.

If you provide more details about your data model and the structure of your table, I can provide more specific assistance.

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

In case there is still a problem, please feel free and explain your issue in detail, It will be my pleasure to assist you in any way I can.

[Pavan_123456789]

Hi @123abc 
I am sharing the google drive link Please find the attached pbix file

https://drive.google.com/file/d/1dJTXsSg_SHyRO1oh0DJzH-D8wk7dlLzG/v...

[Pavan_123456789]

Thank you for tour replay @123abc I tried to handle the subtotal but i am getting grand total of whole First month Qty here i filtered SG only thats why is is showing 5191379 in First month qty 
I tried to filter the data based on measure but i am getting the Placeholder error

I will try to share the pbix file