Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
I have a issue with measure YTD when I filter Date.
I have a table SalesInOut(MonthYear, DateID, Amount, Quantity, SalesType, FreeItem, YearID, PeriodID).
I create a clustered column chart with
- axis: MonthYear,.
- value:
Sales Out Value = CALCULATE(SUM(SalesInOut[Amount])/1000000,SalesInOut[SalesType] = "O", SalesInOut[FreeItem] = FALSE())
I create a KPI with:
- Indicator:
ABSValSI = var x = CALCULATE(MAX(SalesInOut[DateID]), ALL(SalesInOut[DateID])) return CALCULATE(SUM(SalesInOut[Amount])/1000000,FILTER( ALLSELECTED( SalesInOut), [YearID] = YEAR(x) && [PeriodID] <= MONTH(x) ),SalesInOut[SalesType] = "I", SalesInOut[FreeItem] = FALSE())
- Trend axis: DateID
When I do not select column in clustered coumn chart, value of KPI is true.
When I select column in clustered coumn chart, value of KPI is false.
Not select: true
Select column MonthYearL 05-2017: value is fail
Can anyone help me?
Hi @pmhoang94,
Did you verified the data when we applied the filter on the table?
1. X will return the max date in the whole table. For example, 20181231.
var x = CALCULATE(MAX(SalesInOut[DateID]), ALL(SalesInOut[DateID]))
If we choose 05-2017, this formula will return blank.
[YearID] = YEAR(x) && [PeriodID] <= MONTH(x)
2. SalesInOut[SalesType] = "O" while SalesInOut[SalesType] = "I" in the KPI.
Maybe these items upper will lead this problem.
Best Regards!
Dale
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |