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 still learning tips and tricks about PowerBI. Right now I'm trying to use the card visual to show a specific measure. I have four levels of filters. If no filter is selected, I want to show a certain value (e.g. 4.43), if choose level 1 filter and no other filters, then it would show another value (4.42), and so on. However, Power BI summarizes the data and if I choose no filter, it will average/sum/count/etc. all the values in the column measure. So, I would like to know if anyone has a solution/workaround to this? I would greatly appreciate if somebody can help me with this.
This is an example of my data:
Thanks in advance!
Please provide sanitized sample data that fully covers your issue. I cannot help you without usable sample data.
Please paste the data into a table in your post or use one of the file services like OneDrive or Google Drive. I cannot use screenshots of your source data.
Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Hi Ibendlin, here is the link to find sample data for my question: Sample Data
I have engagement scores for my company and its divisions. In the dashboard, I created 3 filters: Business Unit, Division and Department Name. If I don't select any filter, it means I am showing the company overall score (4.50). If only want to filter by Business Unit and select HeadOffice, the result should be 2.10. The empty cells refer to when there is no filter selected in that level.
Hope this makes it clear and thank you for helping out!
Thank you for providing the sample data. That helps a lot with proposing a potential solution.
Your expected result is not supported by the facts you provided. For stores you have an average engagement of 3.8 but your individual store values are
All of these are lower than 3.8, so even with weighting there is no way to reach that average.
Note: In general you don't need to do the manual roll-ups, you can let the data do the work for you.
User | Count |
---|---|
123 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
183 | |
90 | |
67 | |
62 | |
53 |