topic Re: How to limit what data is shown based on measure outcome in DAX Commands and Tips

How to limit what data is shown based on measure outcome

Amy-Marriott — Tue, 02 Jul 2024 14:10:22 GMT

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

Re: How to limit what data is shown based on measure outcome

lbendlin — Wed, 03 Jul 2024 01:42:43 GMT

RETURN IF(Percentage>0.05,Percentage)

Re: How to limit what data is shown based on measure outcome

Amy-Marriott — Wed, 03 Jul 2024 07:35:54 GMT

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"))

Re: How to limit what data is shown based on measure outcome

lbendlin — Wed, 03 Jul 2024 15:43:42 GMT

For example

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