Forum Discussion
Paco-MK2
4 years agoNew Member
Issue calcultated measures analysis services tabular
Hi all, We have an issue regarding our Power BI reports that are based on a analysis services tabular instance (compatibility level 1500). In the cube there are a few measuregroups/tables t...
Paco-MK2
4 years agoNew Member
Hi,
Thank you for your time!
It is a Tabular Model not Multidimensional Model.
The weird thing is that the user can create calculations in Power BI, but the error only occurs when a calculation is made on a calculation AND a specific relation is selected. The relation works when the measure itself or a calculation is made on the measure. It does NOT work when a calculation is made on the calculation.
So for example:
the calculation below works
Budget Bruto Loonomzet =
CALCULATE(
[Budget],
'Grootboekrekening'[CategoryDescription] IN {
"Bruto XXXXXX"
}
)
This one works when the relation/dimension is not selected, but when the dimension is selected does not work
Budget Bruto Loonomzet =
CALCULATE(
[Budget Bruto Loonomzet],
FILTER(
ALLSELECTED('Date'[Month]),
ISONORAFTER('Date'[Month], MAX('Date'[Month]), DESC)
)
)
Best regards,
v-janeyg-msft
Community Support
4 years agoPaco-MK2 Any updates?