Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
42 | |
28 | |
24 | |
20 | |
16 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |