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.
Hello,
I have a fact table that has multiple colums:
Item,Period_Name,Period_ID,Sales
Period name is like Jan 2022 , Feb 2022 etc
Period_ID is like 202201 , 202202 etc
I created one slicer in the dashboard that has "Period_Name" Field and created 1 grid in the dashboard in which I want to include 4 columns: Item, Period, Sales Value, Sales value (for the all selected periods) , Sales Value (for all the periods selected and unselected)
I created the measures like this
I tried so much to solve it and solved successfully by changing in the measures
Solved! Go to Solution.
I found the solution to whom it may concern.
The reason is because the Period Column was sorted by Period ID Column, in this situation you have to include both columns in ALL and ALLSELECTED.
Refer to this video
https://youtu.be/rvpKSH3zRcg?t=465
I found the solution to whom it may concern.
The reason is because the Period Column was sorted by Period ID Column, in this situation you have to include both columns in ALL and ALLSELECTED.
Refer to this video
https://youtu.be/rvpKSH3zRcg?t=465
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 |
---|---|
39 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
44 | |
32 | |
30 | |
18 | |
17 |