Forum Discussion

ibuhary's avatar
ibuhary
Helper I
7 years ago
Solved

Calculated column to work on Filtered Time / Date Range

Hello Everyone,   I currently have the following calculated column:   MktShareProduct =Table3[Traded Volume]/CALCULATE(SUM(Table3[Traded Volume]),ALLSELECTED(),FILTER(Table3,Table3[Product2]=EARL...
Need Help
  • ibuhary's avatar
    ibuhary
    7 years ago

    I managed to solve it guys,

     

    Here is the new Calculated Measure:

     

    MktShareProductNew = DIVIDE(sum(Table3[Sales]),CALCULATE(SUMX(Table3,Table3[Sales]),ALLEXCEPT(Table3,Table3[Product2],Table3[Clear Year-Month])),BLANK())

     

    Thanks for all the time from you...

ibuhary's avatar
ibuhary
Helper I
7 years ago

I managed to solve it guys,

 

Here is the new Calculated Measure:

 

MktShareProductNew = DIVIDE(sum(Table3[Sales]),CALCULATE(SUMX(Table3,Table3[Sales]),ALLEXCEPT(Table3,Table3[Product2],Table3[Clear Year-Month])),BLANK())

 

Thanks for all the time from you...