This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreLevel up your Power BI skills this month - build one visual each week and tell better stories with data! Get started
Have date slicer with set relative boundaries (e.g current calendar year). When the sliders are set to the defined boundaries (i.e. full 12 months), the row count returned by the SSAS model for the calendar (i.e. the filtered subset which should be effected by the above defined relative boundaries in the slicer) is the same as the row count for the entire calendar.
This is problematic in so far the SSAS measures are not counting items correctly. Have a SSAS measure that is calculating the number of items that exist within that defined range (note the calendar table is not related to the measure table). SSAS measure essentially is calculating the count as if the entire calendar has been selected rather than just the slicer date range.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.