Forum Discussion
Import from SSAS Cube: Measure duplicated across Dimension Attributes.
Hi, I am wondering whether someone can help me out on the below! I am importing from a Analyses Services: Measures: - Sales Retail - Sales Online Dimensions: - Week - Online Payment ...
Anonymous,
It seems that you use "Connect Live" mode to connect to SSAS. In Power BI Desktop, there is no workaround.
In SSAS, you can find your measure, and set the value of IgnoreUnrelatedDimensions to True. This way, for unrelated dimensions, the measure will show blank values.
Regards,
Lydia
Thanks Anonymous
Still to try this. Once i do, i will be sure to get back with the outcome!