Forum Discussion
SSAS Calculation Groups in Report Builder
I'm building reports in Power BI Report Builder using calculation groups (time intelligence) in a live connection to an SSAS Tabular model. Reporting Services is querying SSAS via an MDX query (since...
There is a little known feature in Report Builder for Multi Value Parameters with DAX. DAX does not natively support MVP's, a placeholder trick was put in the query designer.
The button on the far right enables the parameters. It is not a perfect solution, but it does work for most cases. The query will only work when run in a current report server, SSDT or Report Builder.
Thanks for the reply. I've known about that feature, but it still doesn't work well with hierarchies and such that I've got going on. Besides, using DAX isn't my issue - the problem is that the calculation groups for time intelligence don't seem to be working.