Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Not easy Question

Hi all, have a problem, This is convertion (opportunity/lead) graph as we see there is quite chaotic , but after a minute you can see patterns.    Then I created a table by employee with con...
General Comment
Need Help
Show and Tell
Tips and Tricks
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi Anonymous 

    You may create a measure to get the correct total,For example:

    Measure =
SUMX ( Table, [Measure 27] )

    If it is not your case,please share some simplified assumed sample data and expected output which would be helpful to provide an accurate solution.For further,please refer to How to Get Your Question Answered Quickly.

    Regards,

v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
7 years ago

Hi Anonymous 

If you want to show the value 91% and 95% as blank,you may create an IF condition like below:

Measure =
IF (
    TRUNC ( [Convertion rate, 2016], 2 ) IN { 0.91, 0.95 },
    BLANK (),
    [Convertion rate, 2016]
)

Regards,

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thank you v-cherch-msft for reply, but after applying trunc , it does not recalculate overall conversion, I have highlited. Do you know why? and how can I remove those date from overall convertion calculation?

  • v-cherch-msft's avatar
    v-cherch-msft
    Microsoft Employee
    7 years ago

    Hi Anonymous 

    You may create a measure to get the correct total,For example:

    Measure =
SUMX ( Table, [Measure 27] )

    If it is not your case,please share some simplified assumed sample data and expected output which would be helpful to provide an accurate solution.For further,please refer to How to Get Your Question Answered Quickly.

    Regards,