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.
Hi everyone,
I have a column 'Letters' includes letters from A to Z ..
I am applying a page filter, that should filter the 'Letters' to be from C to X ..
Whenver I make any calculation to take MIN(Letters) , I always get the A ..
Is there a way to include the page filter in the calculation , to make MIN(Letters) = C ?
Here's the pbix file: https://drive.google.com/file/d/1C8aPCQPa6l5AKwEwAiW1HShbTVmK85_e/view?usp=sharing
Thanks in advance 🙂
Solved! Go to Solution.
I looked at your file. The reason is that you used MIN in a calculated column, which do not respond to slicers. You need to make a measure like this, and use it in your card.
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
I looked at your file. The reason is that you used MIN in a calculated column, which do not respond to slicers. You need to make a measure like this, and use it in your card.
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Please explain your model more. For example, how are you filtering from C to X? Does that table have an index column and you are using those number to filter it? If you make a table visual, do you confirm that the A row is filtered out by the page filter?
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Thanks @mahoneypat for your reply,
please find the file here: https://drive.google.com/file/d/1C8aPCQPa6l5AKwEwAiW1HShbTVmK85_e/view?usp=sharing
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 |