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...
I understand the concept of filter and slicing visuals.
at the moment I am looking for a way to drop my calculated column and go for a new Measure.
Please see my previous reply for more details.
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
