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.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , In the donut chart you should use Won as Legned. and sum(Table[price]) as measure

 

 

Or you need two measure

Won%= DIVIDE(

CALCULATE(SUM('Sales'[Sales_Price]),'Sales'[Won]="Yes"), 
SUM('Sales'[Sales_Price]))

 

Lost %= DIVIDE(

CALCULATE(SUM('Sales'[Sales_Price]),'Sales'[Won]<> "Yes"), 
SUM('Sales'[Sales_Price]))

 

If needed use filter

 

Won%= DIVIDE(

CALCULATE(SUM('Sales'[Sales_Price]),'filter('Sales','Sales'[Won]="Yes")), 
SUM('Sales'[Sales_Price]))