Forum Discussion
Dynamic calculation based on helper table and selected period
Hi, I have seen many posts and video related to my question, however nothing seems to be working as I expected, though I have tried several option and combinations. Hence seeking help herewith. Sce...
gmsamborn thank for your reply.
as i mentioned previsouly, my selected period is not the date but status
VAR _SelectedPeriod = SELECTEDVALUE( 'Selection Period Table'[Selected Period] )
this would be
VAR _SelectedPeriod = SELECTEDVALUE( 'Selection Period Table'[Period Status] )at the same time i want to make the report dynamic based on Period status = Selected period.
I tried the above code an static date, all works fine excep, the date is hardcoded now and the total value of "New Value" is not correct.
gmsamborn
Super User
Super UserHi saqwild
If both are in the same table, DAX can figure this out if you are using SELECTEDVALUE() since it looks at the whole row, not just the field in the slicer.
Check my pbix.
thank you gmsamborn, that works fine,
juse one issue now, when i try values by ageing groups, it always shows 100% bucket
thanks