Extra Periods appearing in multiple measures multiple Dimensions in a Combo Chart, Different expression for

jazzsran — Fri, 15 Nov 2024 21:22:53 GMT

Hello All,

I have an urgent requirement

In a Combo Chart with two alternate Dimensions and 3 measures.

For week, we need to show only latest/Current Month and for Month: it shows targets till Next Year End.

For Actuals it is working fine but when I add 'Target' and 'Target%' measures, something is not working and making Actuals to show data for extra weeks. Issue is occurring only for 'Week' dimension

Details below:

Dimensions:

'Year Month' and 'Week'

Measures:

1. Target:

Pick(Match(GetObjectDimension(),'Year Month','Week'),
Max({$<[_SourceTable]={'Monthly_Target_Table'}>}"Target Monthly"),
Max({$<[_SourceTable]={'Weekly_Target_Table'},YearMonth={'$(=$(vLatestMonth))'}>}"Target Weekly")

2. Actuals:

Pick(Match(GetObjectDimension(),'Year Month','Week'),
Sum({$<[_SourceTable]={'Monthly_Target_Table'}>}"Actuals Monthly"),
Sum({$<[_SourceTable]={'Weekly_Target_Table'},YearMonth={'$(=$(vLatestMonth))'}>}"Actuals Weekly")

3. Target%:

=Pick(Match(GetObjectDimension(),'Year Month','Week'),
(Sum({$<[_SourceTable]={'Monthly_Target_Table'}[Dynamic Option]=,ClaimDataType=>}Std_Units)
/
(Max({$<[_SourceTable]={'Monthly_Target_Table'}[Dynamic Option]=,ClaimDataType=>}[Target Monthly]))),
(Rangesum(above(Sum({$<[_SourceTable]={'Weekly_Target_Table'},[Dynamic Option]=,YearMonth={'$(=$(vLatestMonth))'},
ClaimDataType=>}Units_weekly),0,rowno()))
/
(Max({$<[_SourceTable]={'Weekly_Target_Table'} ,[Dynamic Option]=,YearMonth={'$(=$(vLatestMonth))'},ClaimDataType=>}"Target Weekly")))
)

Screenshot for reference:

Data is available only for Target and Actual - I have hidden the data for confidentiality reasons.

Should only show first 3:

Thanks and Regards

topic Extra Periods appearing in multiple measures multiple Dimensions in a Combo Chart, Different expression for in App Development

Extra Periods appearing in multiple measures multiple Dimensions in a Combo Chart, Different expression for