Measure returning wrong value after filter

[reiskleiton]

Hi Power Bi Community, 

I am having a problem to create a measure in the right way.

I need to create a measure that return the Week Percentual from Accumulated and Today Volume percentual from Accumulated.
Well, I have created three measures that return that Accumulated, Week Accumulated, and Today Accumulated.

Accumulated = SUMX('MSForms Pivot', 'MSForms Pivot'[Volume])

Week =

CALCULATE (

    SUM ('MSForms Pivot'[Volume]),

    FILTER ( 'MSForms Pivot',

        WEEKNUM ([DataColeta]) = WEEKNUM (TODAY())

    )

)+0

Today =

CALCULATE (

    SUM ('MSForms Pivot'[Volume]),

    FILTER ('MSForms Pivot',

        'MSForms Pivot'[DataColeta] = TODAY())) + 0

Then, I created a new measure that return the percentage of Week and Today from Accumulated.

Week Percentage = CALCULATE(DIVIDE([Week], [Accumulated]))

When there is no filter applied to the dashboard, it gives the right result, but when a company is filtered, it gives me the wrong Week Percentage result for this company.

For example:

The Percentage of this week is 28.8 from the Accumalated (1336 * 100 / 4636).

But if I select a company 1, it does not return the value from Percentage Week.

Company	Week	Accumulative	Percentage Week	Percetage from Total
1	675	975	50.52	21.03
2	397	697	29.72	15.03
3	75	375	5.61	8.09
4	45	345	3.37	7.44
5	35	335	2.62	7.23
6	33	333	2.47	7.18
7	28	328	2.10	7.08
8	25	325	1.87	7.01
9	23	323	1.72	6.97
10	0	300	0.00	6.47
11	0	300	0.00	6.47
Total	1336	4636	100.00	100.00

[Ashish_Mathur]

Hi,

Follow this process

1. Create a Calendar Table with calculated column formulas for Year, Month name, Month number and week number.  Sort the Month name column by the month number
2. Create a relationship (Many to One and Single) from the Date column of MSForms Pivot Table to the Date column of the Calendar Table
3. Write/simplify these measres

Accumulated = SUM('MSForms Pivot'[Volume])

Today's week = weeknum(today())

Week = CALCULATE([Accumulated],FILTER (Calendar,Calendar[Weeknum] = [Today's week]))

Hope this helps.

[reiskleiton]

Hi Ashish,

Thank you for you help.

I've tried what told me to do, but it doesn't work. Still getting the same result as before.

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.  Show the problem and expected result very clearly.