Forum Discussion

Bobbertsan's avatar
Bobbertsan
Regular Visitor
4 years ago
Solved

One Slicer, two filters

We have a user who wants me to create two visualizations. She wants the first visualization to filter data based on a slicer. For example, she wants to show all losses for 2021 by using a slicer boun...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, Bobbertsan ;

    Such as jdbuchanan71 said, which could create a measure when live connect. it called report-level DAX meaure；

    However You can't create report level measures when authoring a report that is connected live to an SSAS multidimensional model. The only measures that are available are measures defined in the MD model.

    Best Regards,
    Community Support Team_ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, Bobbertsan ;

Such as jdbuchanan71 said, which could create a measure when live connect. it called report-level DAX meaure；

However You can't create report level measures when authoring a report that is connected live to an SSAS multidimensional model. The only measures that are available are measures defined in the MD model.

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.