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.
Dear all,
I have two subjects\issues that I sent a request for help, however, there was a reply from people who tried to help, but I didn't get the solution and still stucking.
so I will try again to present my problem in a different way:
1- first one:
I was facing a problem with a measure not responding to the additional filters my measure is: IDP by year = var y = MAX(Append1[Year])
return
CALCULATE([IDP Arrived IND 2018+2019],FILTER(ALL(Append1),Append1[Year]=y))
so when I am filtering by the date it's working well but if I used other filters such as drill down the location for example, it's not filtering down the number accordingly,
so i figured out that the problem is ''All'' but i couldn't figure out the replacement to it or the other solution!!
P.S
[IDP Arrived IND 2018+2019] this measure is a simple sum between three columns
The ALL() statement clears ALL filters on the append1 table. If you want to remove the filters on the date column but maintain the other filters you should have a seperate table for your dates, which you then apply the ALL statement to.
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |