Forum Discussion

vally57's avatar
vally57
Icon for Helper I rankHelper I
2 years ago
Solved

dax measure

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



Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.