Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Alternative to calculate function

I'm attempting to use the calulate function to sum a result and apply filters. However the calcultate function only seems to allow me to use a column as a reference but my reference is a measure. Is there a workaround for this in the Calculate function or is there another Dax function that will allow me to sum my measure and apply filters?

 

 

Need Help
  • Kaviraj11's avatar
    Kaviraj11
    2 years ago

    Hi,

     

    Just put the measure in place of sum(percentcol), so it should be CALCULATE(COALESCE(percentcol,0)......). The measure be calculated accordingly.

1 Reply

  • Kaviraj11's avatar
    Kaviraj11
    Solution Sage
    2 years ago

    Hi,

     

    Just put the measure in place of sum(percentcol), so it should be CALCULATE(COALESCE(percentcol,0)......). The measure be calculated accordingly.