Level Of Detail Inquiry

Hi, Anonymous 

I am not familiar with formulas in Tableau.

Did you want to group by Segments in powerbi to get the minimum  value of [ITEM_COST]  * [QUANTITY_RATE]) ?

Please try formula as nelow:

M_Cost = 
CALCULATE (
    MAX ( 'Table'[Cost] ),
    FILTER (
        ALL ( 'Table' ),
        'Table'[ORGCODE] = "SGW"
            && 'Table'[SEGMENTS] = MAX ( 'Table'[SEGMENTS] )
    )
)

M_Rate = 
CALCULATE (
    MAX ( 'Table'[Rate] ),
    FILTER (
        ALL ( 'Table' ),
        'Table'[ORGCODE] = "CDW"
            && 'Table'[SEGMENTS] = MAX ( 'Table'[SEGMENTS] )
    )
)

FIXED Level of detail value = 
[M_Cost]*[M_Rate]

Please check my sample file for more details.

If doesn't meet your requirement , please explain the formula in detail.It will be better if you can share you expected in excel.

Best Regards,
Community Support Team _ Eason