TOTAL Matix viz help

[ak77]

Hi All,

I need help in solving the below issue. Please check

i have a dataset and needs to show the total in Matrix Viz for date range selected which i have done .

The requirement i need help is the TOTAL calculation for Holding Column should not be from its below values
but it should be the total value of the Holding classification for which the Holding data belongs to.

For Example: from the below ' In'  Classsification has 3 Holdings circled in blue and Total should not be from the below red circled values (which is a default sum) .  The logic should sum up all the 'In' Classification values for a selected  date range and display them in Total 

Sample report is attached in the below link

https://drive.google.com/file/d/1r6qo4ur-obTtzyz6uFq1D-7xLzOPKEaQ/view?usp=sharing

[Ashish_Mathur]

Hi,

Your question is not clear.  Please show the expected result very clearly.

[Daniel_PowerBI]

Hi,

Can you try this measure:

Sum = CALCULATE(SUM('Table'[Market_Value_Cash_Flow_Adjusted_Beginning]),'Table'[Holding_Classification] = "IN")

[thuoc115]

thank you

[ak77]

Hi @Daniel_PowerBI , thanks for reply

The one u suggested only works for IN. i need a generic logic which works for all Holding_Classifications

[Daniel_PowerBI]

So for july 1st 2013 you want this right?

[ak77]

@Ashish_Mathur @thuoc115 @Daniel_PowerBI , Thanks for reply.  I am trying it difficult to explain. wil reply shortly with example