Forum Discussion
Solved
Formula to Sum a Measure Based off Multiple Columns
Hello, I have 2 columns in my table and one measure 1. Portfolio Code - Column 2. Fund Strat% - Measure 3. Run Date - Column I want to sum the values in "FundStrat%" (measure) by portf...
Hello,
Thank you for your help. I figured out the formula to sum a measure.
Formula to sum a measure = SUMX(VALUES(your table name),[measure])
Hi gmasta1129
As per my understanding of your requirement.
could you please try the below dax?
Total Fund Strat% by Portfolio and Date =
CALCULATE(
[Fund Strat%],
ALLEXCEPT(
'YourTable',
'YourTable'[Portfolio Code],
'YourTable'[Run Date]
)
)
If this answers your questions, kindly accept it as a solution and give kudos.