cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
einarrattgard
Helper III
Helper III

MIN is larger than MAX in calculated column

Hello!
I have made 2 calculated columns in "Supplier Table":

MinOD = 
CALCULATE(
    MIN(Data[Ø Ext]),
    FILTER(
        Data,
        AND( 
            AND(
                Data[HRR Supplier] = 'Supplier Table'[Supplier],
                Data[Turned Ring Supplier] = 'Supplier Table'[Turner]
            ),
            Data[Product type] = 'Supplier Table'[Product]
        )
    )
)
MaxOD = 
CALCULATE(
    MAX(Data[Ø Ext]),
    FILTER(
        (Data),
        AND( 
            AND(
                Data[HRR Supplier] = 'Supplier Table'[Supplier],
                Data[Turned Ring Supplier] = 'Supplier Table'[Turner]
            ),
            Data[Product type] = 'Supplier Table'[Product]
        )
    )
) 

As you can see, the only difference is that one is using MAX and the other one is using MIN. 
However, this is the result they provide:

einarrattgard_0-1629356740559.png

The data-table looks like this 

einarrattgard_2-1629357007487.png

 

There is no relationship between the tables.

I have also controlled that there are smaller values than both the max- and min-functions.

Thank you

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@einarrattgard , Can you check data type of Data[Ø Ext], I think it is text data type. It should be some number data type



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@einarrattgard , Can you check data type of Data[Ø Ext], I think it is text data type. It should be some number data type



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

You are right, that was embarrasing....

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!