How to limit what data is shown based on measure outcome

[Amy-Marriott]

Hi there,

I have created the below measures:

ID = DISTINCTCOUNT(ID) 

Filtered Result = CALCULATE('Table'[ID], FILTER('Table','Table'[Column] = "Yes"))

I have then found the % by doing the below measure:

Percentage = [Filtered Result] / [ID] then converted to %.

What I need to do is make sure that the outcome of the Percentage is only calculating the Filtered Results when they are larger than 5 for example I have 100 ID, 3 Filtered Result therefore I need the Percentage to show 0 or not calculate and only calculate when the filtered result is over 5.

Please could someone assist in making this happen?

Thanks

[lbendlin]

RETURN IF(Percentage>0.05,Percentage)

[Amy-Marriott]

Thank you - where would this go please? Also it isn't the percentage that is 0.05 it is the fitered results count - Filtered Result = CALCULATE('Table'[ID], FILTER('Table','Table'[Column] = "Yes"))

[lbendlin · Accepted solution]

For example

Percentage = 
Filtered  = CALCULATE(DISTINCTCOUNT('Table'[ID]), 'Table'[Column] = "Yes")
Perc = Divide(Filtered,DISTINCTCOUNT('Table'[ID]))
RETURN IF(Perc>0.05,Perc)