Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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 :
That's easy to do with page filters when the three branches are set in stone. What she wants is to be able to selected which 3 branches (out of their 30 branches) to display. So far that's also easy using "Edit Interactions": am able to assign one slicer per set of columns. But when comes the time to calculate the 6 month average of those selected branches and calculate the N count (bottom left corner - should read 17 since in July for those three branches, there was a total of 17). I don't know how to calculate this properly.
An example of a measure that calculates the 6 month average:
If someone can help me figure out how to achieve the client's desires, I would very much appreciate it.
Thank you!
Solved! Go to Solution.
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.
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.
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.
User | Count |
---|---|
119 | |
66 | |
65 | |
56 | |
50 |
User | Count |
---|---|
177 | |
84 | |
70 | |
64 | |
54 |