dax measure

[vally57]

i have a calculated column like this
IF('Facts'[Customer]=BLANK(),BLANK(),
Facts'[Return Delivery])
i tried to convert this to measure like this

IF(MAXX('Facts','Facts'[Customer])=BLANK(),BLANK(),SUM('Facts'[Return Delivery])),
but the measure i have created is not filtering the values if customer is blank for [Return Delivery], instear i'm getting sum[Return Delivery].Please help in modifying the above logic

TIA

[v-yifanw-msft · Accepted solution]

Hi @vally57 ,
Depending on the information you provided, you can follow the steps below:

1.Add a measure.

Return Delivery Measure = 
CALCULATE(
    SUM('Facts'[Return Delivery]), 
    'Facts'[Customer] <> BLANK()
)

Final output:

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[vally57]

@amitchandak can you help me on this