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,
Looking for the picture down below P HC supposed to be 0, as I slice on "PermTmpCOD" = T. The measure is standard P HC = CALCULATE ( [HC], PermTmpCOD = "P"). I tried with ALLSELECTED but it didnt work. For the datamodel its standard one to many connection, two tables
Solved! Go to Solution.
Hi there!
Try the following:
CALCULATE ( [HC], KEEPFILTERS( PermTmpCOD = "P" ) )
Let me know if that helps!
Hi there!
Try the following:
CALCULATE ( [HC], KEEPFILTERS( PermTmpCOD = "P" ) )
Let me know if that helps!
It works! Can you elaborate a little what you've done?
Sure thing!
So, when you apply a "filter" with CALCULATE, you are essencially removing any existing filter applied to the same column, replacing it with the new filter that you defined. If you dont want to lose the existing filter, then KEEPFILTERS comes in handy as it will keep the filter that you applied outside of the measure, and also the filter applied on your CALCULATE function.
For a better understanding of this I suggest reading this posts:
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 | |
96 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |