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.
Hello,
I have a data table that looks like the following table. I am trying to create a bar chart that show the % Spend by Date and Type of Produce while filtering the table for Location = Grocery Store and Day = Monday or Tuesday.
LocationDayProduceTypePrice
Grocery Store | Monday | Apple | Fruit | 5.00 |
Farmers Market | Tuesday | Cucumber | Vegetable | 2.00 |
Grocery Store | Wednesday | Orange | Fruit | 6.00 |
Farmers Market | Monday | Peas | Vegetable | 8.00 |
Farmers Market | Tuesday | Banana | Fruit | 1.00 |
Grocery Store | Monday | Pineapple | Fruit | 10.00 |
Grocery Store | Monday | Carrots | Vegetable | 2.00 |
Grocery Store | Tuesday | Cucumber | Vegetable | 0.75 |
I am trying to get something like this:
However, when I try to do it in DAX using the following expression:
I get the following result:
What am I doing wrong? I am able to apply multiple filters within the same expression, why does adding "AllSelected" break it? How can I calculate the % of the total while filtering the data?
Any help would be greatly appreciated!
Solved! Go to Solution.
Hi @newpbiuser01
Please use these measures
pbix is attached
Hi @newpbiuser01
Please use these measures
pbix is attached
User | Count |
---|---|
123 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
183 | |
90 | |
67 | |
62 | |
53 |