Forum Discussion
Calculated column to work on Filtered Time / Date Range
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...
Hey,
it was not clear to me that you were looking for a measure, at least not to me.
maybe this measure provides what you are looking for:
p100 =
DIVIDE(
CALCULATE(
SUM(Table1[amount])
)
,CALCULATE(
SUm('Table1'[amount])
,ALLSELECTED('Table1')
)
,BLANK()
)
This leades to a report that looks like this:
If this is not what you are looking, you might consider to create a pbix file that contains the data shown in the screenshot of your last post, upload the pbix to onedrive or dropbox and share the link.
Regards,
Tom
It seems close to what I look for. But needs more tweeks.
The percentages should sum up to 100% by each product.
Thats why I call the measure Market Share of Sales by "Product", and not just Market Share by Sales.
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
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.