Calculating Current Week Percentage Score, Previous Week Percentage Score and Change of Over Change

Anonymous — Tue, 31 Jan 2023 05:47:18 GMT

When I use these formalas I am not getting any values, it return blank, the Total Score is in Percentage

Score Current Week =

CALCULATE ( [TOTAL Score], DimDate[Week Offset] = 0)

Score Prior Week =

CALCULATE([TOTAL Score],DimDate[Week Offset] = -1)

Score Week Over Week Change =

[Score Current Week] - [Score Prior Week]

Re: Calculating Current Week Percentage Score, Previous Week Percentage Score and Change of Over Change

FreemanZ — Tue, 31 Jan 2023 06:04:46 GMT

hi Anonymous

what fitler context do you have for the three measures?

what code do you have for [TOTAL Score]?

how does the DimDate[Week Offset] column look like?

Re: Calculating Current Week Percentage Score, Previous Week Percentage Score and Change of Over Change

Anonymous — Tue, 31 Jan 2023 13:37:37 GMT

Hi FreemanZ

Kindly please find the information you requested below.

DimDate is as follows, I copied only few dates:

Date	Year	Quater	Week Number	Month Number	Month	Day Of Week	Week Offset
Sunday, 22 January 2023	2023	Q1	4	1	January	Sunday	-1
Monday, 23 January 2023	2023	Q1	4	1	January	Monday	-1
Tuesday, 24 January 2023	2023	Q1	4	1	January	Tuesday	-1
Sunday, 29 January 2023	2023	Q1	5	2	January	Sunday	0
Monday, 30 January 2023	2023	Q1	5	2	January	Monday	0
Tuesday, 31 January 2023	2023	Q1	5	2	January	Tuesday	0
Sunday, 4 February 2023	2023	Q1	6	2	February	Sunday	1
Monday, 5 February 2023	2023	Q1	6	2	February	Monday	1
Tuesday, 6 February 2023	2023	Q1	6	2	February	Tuesday	1

The first Dax Measure:

VMScorecard =
VAR VMPoints = 10
VAR VMScore =
COUNTROWS (
FILTER (
FactData,
FactData[Details.score]
|| FactData[Captured.score]
|| FactData[Record.score]
|| FactData[AssistantRecord.score] > 0
)
) / [Total None Business]
RETURN
( VMScore * VMPoints ) / 100

The Second Dax Measure:

VM (Normal) =
AVERAGEX (
VALUES ( FactData[customer_data.customerid] ),
[VMScorecard]
)

Third Dax Measure:

GMSScorecard =
VAR GMPoints = 10
VAR GMScore =
COUNTROWS (
FILTER (
FactData,
FactCallData[Used.score] > 0
)
) / [Total None Business]
RETURN
( GMScore * GMPoints ) / 100

Fourth Dax Measure:

GM (Normal) =
AVERAGEX (
VALUES ( FactData[customer_data.customerid] ),
[GMSScorecard]
)

Fifth Dax Measure:

TOTALS = ([GM (Normal)] + [VM (Normal)])

6th Dax Measure, this is where the total score comes from:

TOTAL Score =
AVERAGEX (
VALUES ( FactData[customer_data.customerid] ),
[TOTALS]
)

Re: Calculating Current Week Percentage Score, Previous Week Percentage Score and Change of Over Change

Anonymous — Mon, 13 Feb 2023 04:45:54 GMT

I managed to solved this.

topic Re: Calculating Current Week Percentage Score, Previous Week Percentage Score and Change of Over Change in DAX Commands and Tips

Calculating Current Week Percentage Score, Previous Week Percentage Score and Change of Over Change

Re: Calculating Current Week Percentage Score, Previous Week Percentage Score and Change of Over Change

Re: Calculating Current Week Percentage Score, Previous Week Percentage Score and Change of Over Change

Re: Calculating Current Week Percentage Score, Previous Week Percentage Score and Change of Over Change