Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
Let me give you an idea about the data I am working with.
Year | Month | Code | DATA | Instances |
2020 | Mar | SI | A | 2 |
2020 | Mar | SC | A | 1 |
2020 | Mar | SI | B | 2 |
2020 | Mar | SC | B | 1 |
2020 | Apr | SI | A | 2 |
2020 | Apr | SC | A | 1 |
2020 | Apr | SI | B | 2 |
2020 | Apr | SC | B | 1 |
“SI” and “SC” are code added with unique ID such as “A” and “B”.
First requirement was; I wanted a column to show the instance of each unique ID based on generic code.
DATA | Instances (SI) | Instances (SC) |
A | 4 | 2 |
B | 4 | 2 |
This is working with the following “Measures”
When I am seeing the total data these measures are working perfectly. But When I am trying to see with monthly filter on – like for Mar or Apr; data is incorrect.
I have a doubt that due to the first measure the problem is there in case of Month filter on.
Can anyone guide me?
Please let me know if I am not clear with my issue.
Solved! Go to Solution.
@utsavlexmark , Try like
Sum Instance = SUM(Data[Instance])
Instances (SI) = CALCULATE([Sum Instance],FILTER(Data,Data[Code]="SI"))
Instances (SC) = CALCULATE([Sum Instance],FILTER(Data,Data[Code]="SC"))
or
Sum Instance = SUM(Data[Instance])
Instances (SI) = CALCULATE([Sum Instance],FILTER(allselected(Data),Data[Code]="SI"))
Instances (SC) = CALCULATE([Sum Instance],FILTER(allselected(Data),Data[Code]="SC"))
allexcept mean only that filter will work
@utsavlexmark , Try like
Sum Instance = SUM(Data[Instance])
Instances (SI) = CALCULATE([Sum Instance],FILTER(Data,Data[Code]="SI"))
Instances (SC) = CALCULATE([Sum Instance],FILTER(Data,Data[Code]="SC"))
or
Sum Instance = SUM(Data[Instance])
Instances (SI) = CALCULATE([Sum Instance],FILTER(allselected(Data),Data[Code]="SI"))
Instances (SC) = CALCULATE([Sum Instance],FILTER(allselected(Data),Data[Code]="SC"))
allexcept mean only that filter will work