Forum Discussion
[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 Calendars | FY24_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
- lbendlin
Super User
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523