Return the values to a measure based on threshold breach

[Anonymous]

Hi,

I'm trying to create a measure to collect a list of customers, that are nearing a particular threshold

Table Name: abc

Enterprise	total_contacts	Contact limit
abc	20	50
eee	85	100
fff	100	100
ccc	110	100

i should get the list of Enterprise for which the total_contacts is greater than 90% threshold of the Contact limit but less than 100%

In the above table, i should get comma separated values to be displayed as a card as follows:

eee

[Ashish_Mathur]

Hi,

Why should the answer be eee.  90% of 100 is 90 and 85 is less than 90.  Based on that data that you have shared, no Enterprise should be returned.

[ribisht17]

Did the provided solution help you? If yes, please mark it accordingly

Regards,

Ritesh

[ribisht17 · Accepted solution]

Hello Deedeedudu,

So for this data source 

Are you looking for such output?

If yes then these are the steps

1. BlankRows = COUNTBLANK(Threshold[Threshold])

2. CountRows = CALCULATE( COUNT( Threshold[Threshold]), ALL(Threshold), ( Threshold[Placeholder]>0))

3.Placeholder = ( ( LEN(Threshold[ThresholdCheck])))

4.CharsAllCount = CALCULATE(SUMX(Threshold,Threshold[Placeholder]),ALL())

5.ThresholdCheck = IF( DIVIDE(Threshold[total_contacts],Threshold[Contact limit]) >=.8 && DIVIDE(Threshold[total_contacts],Threshold[Contact limit]) < 1,Threshold[Enterprise],"")

6.SolutionCard = MID( CONCATENATEX(Threshold,Threshold[ThresholdCheck],","),Threshold[BlankRows]+1,[CharsAllCount]+Threshold[CountRows])

Regards,

Ritesh | Ritesh is Dancing with Data - YouTube 

Please mark the answer if it helps so that it can help others as well

[ribisht17]

Hello,

eee is 85% of the Threshold limit(100) ?

Did not get your last point?Please clarify

Regards,

Ritesh

[Anonymous]

Sorry threshold to be set at 80% and not 90%.