Forum Discussion

ak77's avatar
ak77
Icon for Post Patron rankPost Patron
2 years ago

TOTAL Matix viz help

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 t...
Need Help
Show and Tell
Daniel_PowerBI's avatar
Daniel_PowerBI
Icon for Advocate I rankAdvocate I
2 years ago

Hi,

 

Can you try this measure:

Sum = CALCULATE(SUM('Table'[Market_Value_Cash_Flow_Adjusted_Beginning]),'Table'[Holding_Classification] = "IN")
 
  • ak77's avatar
    ak77
    Icon for Post Patron rankPost Patron
    2 years ago

    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's avatar
      Daniel_PowerBI
      Icon for Advocate I rankAdvocate I
      2 years ago

      So for july 1st 2013 you want this right?

       

  • thuoc115's avatar
    thuoc115
    Icon for Advocate I rankAdvocate I
    2 years ago

    thank you