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

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.

Reply
Anonymous
Not applicable

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

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

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

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

Anonymous
Not applicable

You are right, that was embarrasing....

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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