Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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 ) )
)
)
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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 ) )
)
)
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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)
User | Count |
---|---|
53 | |
22 | |
18 | |
18 | |
13 |
User | Count |
---|---|
89 | |
87 | |
50 | |
34 | |
22 |