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
NoaLowraee
Frequent Visitor

Minimum of value based only on slicer filters

Hello ,

I have a problem on the calculation of the minimum of a column.

I want to find the origine of the last puchased project by (client, year , month and program ). 

My measure I want to display is : 

     for each origin how much client got the last purchased project through them ? 

 
Below my exemple. 

 

NoaLowraee_4-1672134958044.png

 

 

I need to get 1 or partenaire site and 0 for call center 

same thing when filtring on a specific program  I need 0 on 

 

NoaLowraee_5-1672134999405.png

 

The dax I used for the Min is as below 

min = calculate( DISTINCTCOUNT(Stores[Client]) , filter( Stores , Stores[Partitionbyyear] = Min((Stores[Partitionbyyear]))))
 

NoaLowraee_6-1672135060684.png

 



Any suggestions will be much appreciated

Thank you in advance

 

2 REPLIES 2
AlB
Super User
Super User

Hi @NoaLowraee 

I do not understand.

1. What is the meaning of the Last Created column?

2. Why are you using MIN( ) if you want the latest date??

3. What would be the expected result if you select Paris? And New York?

4. Why Store1 appears first in Norway and then in Singapore???

 

SU18_powerbi_badge

Please accept the solution when done and consider giving a thumbs up if posts are helpful. 

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

 

 

Hello, 

Thank you for your reply.

I updated My Topic to be more concise possible.

Thank you in advance for your reply.

Helpful resources

Announcements
PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors