Row % with total part of a rolling total

[Senrsi]

Hey i am just started working with Power BI and i am trying to get a precentage of a row total for a coulumn group that is looking at a time frame.  I had no issues getting this to work for a single month but when i try to replicate this with a timeframe i am hitting a wall.

I am usining the DAX code:

Rolling % =

DIVIDE(

CALCULATE(

SUM(MarketShare[Revenue]),FILTER(ALL(MarketShare[Date]),MarketShare[Date] <= MAX(MarketShare[Date]) && MarketShare[Date] >= MAX(MarketShare[Date])-365)),

CALCULATE(

SUM(MarketShare[Revenue]),FILTER(ALL(MarketShare[Date]),MarketShare[Date] <= MAX(MarketShare[Date]) && MarketShare[Date] >= MAX(MarketShare[Date])-365),

ALL(MarketShare[Competitor])

))

But the results is returning 100%.  Is there something that i am missing?

Current View
LOCATION	C1	C2	C3	C4	C5	Total
L1	1000	500	250	500	1000	3250
L2	1300	1000	500	750	900	4450
L3	800	850	700	600	900	3850
Wanted View
LOCATION	C1		C2		C3		C4		C5		Total
L1	1000.00	30.8%	500.00	15.4%	250.00	7.7%	500.00	15.4%	1000.00	30.8%	3250.00
L2	1300.00	40.0%	1000.00	30.8%	500.00	15.4%	750.00	23.1%	900.00	27.7%	4450.00
L3	800.00	24.6%	850.00	26.2%	700.00	21.5%	600.00	18.5%	900.00	27.7%	3850.00

[v-lionel-msft]

Hi @Senrsi ,

Has your problem been solved?

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ashish_Mathur]

Hi,

In the image that you have shared, there is no mention of any time frame/slicer.  Share the download link of your PBI file where one can clearly see the problem for a slicer selection.  Please also show your expected result.

[v-lionel-msft]

Hi @Senrsi ,

Is this what you want?

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Senrsi]

Lionel Chen

Sorry for the delayed respones.  Your solution does work for me for a single month but the issue i am having is that it is a rolling time frame that is looking back 3 months.  I tried posing my power bi File to show but for some reason i am having issues with my Posting attachments.

To compare it to what you provided my table has four coulmns Location, Date, Attribute, Value

Regards