Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Create a calculation based on the result of a page filter

Hi everyone, 

I have a column 'Letters' includes letters from A to ..
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 🙂

1 ACCEPTED SOLUTION
mahoneypat
Microsoft Employee
Microsoft Employee

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.

 

Min Letter Measure = MIN('Table'[Letter])
 
Regards,
Pat




Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


View solution in original post

3 REPLIES 3
mahoneypat
Microsoft Employee
Microsoft Employee

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.

 

Min Letter Measure = MIN('Table'[Letter])
 
Regards,
Pat




Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


mahoneypat
Microsoft Employee
Microsoft Employee

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





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


Anonymous
Not applicable

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.