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...

TomMartens's avatar
TomMartens
Super User
7 years ago

Hey,

 

I guess then you should consider to an xlsx with sample data, a sheet that contains the data and onee or more sheets that should reflect your filtering and the result you expect. Put that sheet to onedrive or dropbox and share the link

 

Your screenshot put a lot of strain to me, to create exactly what you want.

 

Regards,

Tom

ibuhary's avatar
ibuhary
Helper I
7 years ago

Google Drive Power BI File

 

Here is the link to download the file.

 

If you see in my reports page, the  Right Bottom most table, I have applied a date filter.

 

I want to show in there 100% for the product for the selected date filter.