Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

[Help] Show entire period values

This is my slicer filters for my dashboard. The table on the right shows the SMI figures (I shall refer this as target sales). There is 5 weeks in period 1 (week 1 to 5) and there is 4 weeks in period 2 (week 6 to 9). Currrently, it is only displaying the sum of the target sales for week 6 and 7. How can I get it to show for the entire period instead (i.e. week 6 to 9)? I would like to retain the ability to filter by weeks. I have been trying for 2 days but I was unable to figure this out. Could someone help me out? Thank you so much for your help in advance! Below is my measure.

Slicers

Measure

 

 

VAR LatestPeriod =
CALCULATE(
    MAX('FY Calenders'[Period]),
    FILTER('FY Calenders', [Net Total Sales (Key Metrics Report)] > 0))

 

 

LatestPeriod calculates the lastest period where there is a sale. 

 

 

Estimates (Finance) = 
VAR SelectedCurrency = SELECTEDVALUE('Currency Selection'[Currency])

RETURN
SWITCH(
    SelectedCurrency,
    "SGD", SUM(FY24_AOP_QO_SMI___Master[LE (SGD)]),
    "MYR", SUM(FY24_AOP_QO_SMI___Master[LE (MYR)]),
    "USD", SUM(FY24_AOP_QO_SMI___Master[LE (USD)])
)

 

 

Estimates (Finance) takes the selected currency in my dashboard and returns the corresponding values from my table. 
Tables

Below is a sample of the tables that I have. 

FY CalendarsFY24_AOP_QO_SMI___Master
This is my custom calendar which I have mapped out. LE (USD), LE (SGD) and LE (MYR) is the planned target figures. 

 

The two tables are connected as such.

 

1 Reply