Forum Discussion

Rlucero2's avatar
Rlucero2
Frequent Visitor
4 years ago
Solved

Matrix Totals

I know this has been covered a few times, I'm just not understanding how I can use the "HASONEFILTER" functi on with a measure. All the examples I have seen are looking at a column, or maybe the ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    4 years ago

    Rlucero2 I think you want:

    Ult Claims LDF Method 3 =
    var vTable = SUMMARIZE('Raw Data','Raw Data'[*Coverage Year],"__Value",[Ult Claims LDF Method])
    RETURN
    IF(HASONEVALUE('Raw Data'[*Coverage Year]),[Ult Claims LDF Method],SUMX(vTable,[__Value]))
Greg_Deckler's avatar
Greg_Deckler
Community Champion
4 years ago

Rlucero2 I think you want:

Ult Claims LDF Method 3 =
var vTable = SUMMARIZE('Raw Data','Raw Data'[*Coverage Year],"__Value",[Ult Claims LDF Method])
RETURN
IF(HASONEVALUE('Raw Data'[*Coverage Year]),[Ult Claims LDF Method],SUMX(vTable,[__Value]))
Rlucero2's avatar
Rlucero2
Frequent Visitor
4 years ago

Thank you! I should have caught that, it's been a long day... 

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    4 years ago

    Rlucero2 We've all been there! 🙂