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
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