Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

DAX Measure and Visual filtering

Hi all,   I got stuck trying to figure out how to solve below issue, hope someone can help me out.   I have a dataset with sales data, containing a column 'Sales_Price", and a column 'Won' with v...
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    Hi, Anonymous 

     

    You can try the following methods.

    Conversion_Rate =
IF (
    SELECTEDVALUE ( Sales[Won] ) = "No",
    "N/A",
    DIVIDE (
        CALCULATE ( SUM ( 'Sales'[Sales_Price] ), 'Sales'[Won] = "Yes" ),
        SUM ( 'Sales'[Sales_Price] )
    )
)

    Is this the output you expect?

     

    Best Regards,

    Community Support Team _Charlotte

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

v-zhangti's avatar
v-zhangti
Icon for Community Support rankCommunity Support
4 years ago

Hi, Anonymous 

 

You can try the following methods.

Conversion_Rate =
IF (
    SELECTEDVALUE ( Sales[Won] ) = "No",
    "N/A",
    DIVIDE (
        CALCULATE ( SUM ( 'Sales'[Sales_Price] ), 'Sales'[Won] = "Yes" ),
        SUM ( 'Sales'[Sales_Price] )
    )
)

Is this the output you expect?

 

Best Regards,

Community Support Team _Charlotte

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Yes, thank you! This is perfect