Fix sum of percentage when selecting multiple date

[Anonymous]

This is my powerbi file:
https://1drv.ms/u/s!Ag9tIyk2ofNRjk0p_3vuRsnAuARs?e=TQjlu3

these are some pics:

  

here's my meausre:

Percentage = 
var NEWtotalrevenue = CALCULATE(SUM(Revenue[Total]),FILTER('Calendar','Calendar'[Date] >= DATE(2022,10,3)))
VAR OLDtotalrevenue = CALCULATE(SUMX(Revenue,Revenue[Amount]*Revenue[Qtty]),FILTER('Calendar','Calendar'[Date] < DATE(2022,10,3)))
VAR totalrevenue = OLDtotalrevenue + NEWtotalrevenue
Var newsalesmanrevenue = CALCULATE(SUM(Revenue[Total]),FILTER('Calendar','Calendar'[Date] >= DATE(2022,10,3)),Revenue[Salesman]="A")
VAR Oldsalesmanrevenue = CALCULATE(SUMX(Revenue,Revenue[Amount]*Revenue[Qtty]),FILTER('Calendar','Calendar'[Date] < DATE(2022,10,3)),Revenue[Salesman]="A")
VAR salesmanrevenue = Oldsalesmanrevenue + newsalesmanrevenue
return
salesmanrevenue/totalrevenue

my issue is weh ni select week 40 and week 41, i want the percentage to be 1.01 not 0.51

[Jihwan_Kim · Accepted solution]

Hi,

Please try to create a measure like below.

Percentage V2 =
SUMX (
    DISTINCT ( 'Calendar'[Week of Year] ),
    DIVIDE (
        CALCULATE (
            SUM ( Revenue[Total] ),
            FILTER ( 'Calendar', 'Calendar'[Date] >= DATE ( 2022, 10, 3 ) ),
            Revenue[Salesman] = "A"
        )
            + CALCULATE (
                SUMX ( Revenue, Revenue[Amount] * Revenue[Qtty] ),
                FILTER ( 'Calendar', 'Calendar'[Date] < DATE ( 2022, 10, 3 ) ),
                Revenue[Salesman] = "A"
            ),
        CALCULATE (
            SUM ( Revenue[Total] ),
            FILTER ( 'Calendar', 'Calendar'[Date] >= DATE ( 2022, 10, 3 ) )
        )
            + CALCULATE (
                SUMX ( Revenue, Revenue[Amount] * Revenue[Qtty] ),
                FILTER ( 'Calendar', 'Calendar'[Date] < DATE ( 2022, 10, 3 ) )
            )
    )
)

[Anonymous]

thank you very much now i want to ask 
i have expense table for week 40 total is 1000
while week 41 total is 1100

i was to make when i select week 40 and week 41 together,
to make a calculations 
(percentage week 40 * expense week 40 ) + (percentage week 41 * expense week 41)