Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have two measures going for Sales this week & Sales previous week. When i try to a slicer or use a filter for these items they do not change. They are the aggregate values still. Can someone please help? I want to be able to use a slicer/filter to pull different text values i.e. Client A, Client B. The measures are below:
Thanks!
Solved! Go to Solution.
@Jpahl2033 try first to replace the ALL('Table1') with ALL('Table1'[WeekRank])
Also use variables, but in this case that wasn't the issue, so write this:
I actually figured it out, but switching out a column name. Thank you so much for your help. I will mark it as completed.
@Jpahl2033 try first to replace the ALL('Table1') with ALL('Table1'[WeekRank])
Also use variables, but in this case that wasn't the issue, so write this:
Thank you for this! It is very close. When I plug in the two new measures you created, the Sales Last Week Numbers do not show up in the table, but the Sales This week numbers do. Have any ideas?
@Jpahl2033 do you use a sort by column in the model for the one you put on the axis?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
93 | |
83 | |
70 | |
65 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |