Forum Discussion

StevenGrenier's avatar
StevenGrenier
Frequent Visitor
7 years ago
Solved

Multiple Slicers for Same Column +Calculations Based on Selections

Hi,   I'm building a pretty heavy report for a client which displays survey results. This client has very particular needs : she wants to be able to see on the same screen : the results of three ...
Need Help
  • StevenGrenier's avatar
    StevenGrenier
    7 years ago

    Unfortunately, due to confidentiality and the fact that the dataset is in direct query, I was unable to share more information. Nonetheless, I was able to devise a solution, by creating three tables with the same branch information each linked to copies of the same column in the main dataset. With this, I was able to use dax and achieve the result I wanted. 

v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi StevenGrenier ,

 

Could you please share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

 

StevenGrenier's avatar
StevenGrenier
Frequent Visitor
7 years ago

Unfortunately, due to confidentiality and the fact that the dataset is in direct query, I was unable to share more information. Nonetheless, I was able to devise a solution, by creating three tables with the same branch information each linked to copies of the same column in the main dataset. With this, I was able to use dax and achieve the result I wanted.