Forum Discussion

cstarr465's avatar
cstarr465
Frequent Visitor
9 years ago
Solved

Dynamic column based on slicer selection (calculating conversion rate)

I have a table called Inbound Leads. This has all our leads, their contact, date of origination, source, etc. I also have a TRUE/FALSE column in there for if they have closed or not. I need to create...
Need Help
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    cstarr465

     

    try with this modification

     

    Conversion =
DIVIDE (
    COUNTROWS ( FILTER ( Table1; Table1[Closed] = TRUE() ) ),
    COUNTROWS ( Table1 )
)

     

     

Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
9 years ago

cstarr465

 

Hi, you can use a measure:

 

Conversion =
DIVIDE (
    COUNTROWS ( FILTER ( Table1; Table1[Closed] = "Yes" ) ),
    COUNTROWS ( Table1 )
)

And in your visual put this:

 

 

Let me know if need more help

 

Regards

Victor

Lima - Peru

  • cstarr465's avatar
    cstarr465
    Frequent Visitor
    9 years ago

    Thanks for the response, I think I'm nearly there!

     

    It returned an error and won't load visuals with the measure: "DAX comparison operations do not support comparing values of type True/False with values of type Text. Consider using the VALUE or FORMAT function to convert one of the values."

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      9 years ago

      Hi,

       

      Replace the "Yes" with TRUE.  Does that work?

      • cstarr465's avatar
        cstarr465
        Frequent Visitor
        9 years ago
        Same result. I'm using an IF statement in excel to produce the TRUE/FALSE, do I need to use something else, or a support column?