Forum Discussion
Helper ICalculate Marketshare over 12months.
Hi, likmalik
You can modify the measure:Add [Date]=SELECTEDVALUE(Sheet1[Date])
VAR total = SUMX ( FILTER ( ALLSELECTED ( Sheet1 ), [Date] >= startdate && [Date] <= enddate&& [Date]=SELECTEDVALUE(Sheet1[Date]) ), [Sales numbers] ) VAR single = SUMX ( FILTER ( Sheet1, [Date] >= startdate && [Date] <= enddate && [Model] = SELECTEDVALUE ( Sheet1[Model] ) &&[Date]=SELECTEDVALUE(Sheet1[Date]) ), [Sales numbers] )Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community SupportHi, likmalik
You can modify the measure:Add [Date]=SELECTEDVALUE(Sheet1[Date])
VAR total =
SUMX (
FILTER ( ALLSELECTED ( Sheet1 ), [Date] >= startdate && [Date] <= enddate&& [Date]=SELECTEDVALUE(Sheet1[Date]) ),
[Sales numbers]
)
VAR single =
SUMX (
FILTER (
Sheet1,
[Date] >= startdate
&& [Date] <= enddate
&& [Model] = SELECTEDVALUE ( Sheet1[Model] )
&&[Date]=SELECTEDVALUE(Sheet1[Date])
),
[Sales numbers]
)
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helper IThankyou v-janeyg-msft is it possible to send me the pbix because I struggle to modify the measure ?
- v-janeyg-msft
Hi, likmalik
I shared the sample In the reply above,You can download and only modify two variables in my old measure.
Best Regards
Janey Guo
- likmalik
It works thank you so much!
4 days that I tried on different forums but no-one was able to help me. You are the king of powerBI.
- v-janeyg-msft
Hi, likmalik
Glad to help you. If I can get kudos, I will also be very happy.😁
Best Regards
Janey Guo