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,
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
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 |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |