Measure for % of data in 1 column equal to 100% or greater

[TXAPpdev89]

I have a column with data and I want to calculate the % of instances in the column that are 100% or greater.  How do I write this?

Sample of data:

File #      Score

31781      103.03

32096      102.33

32565      92.5

45698      98.5

58887      89.5

I'd also like a measure for count of Files # =<100%

Thank you!

[parry2k · Accepted solution]

@TXAPpdev89 

Measure Count = COUNTROWS ( Table )

Measure Count Above 100 = 
CALCULATE ( 
   [Measure Count],
   Table[Score] > 100 //if value is stored in % then change 100 to 1
)

Measure Count Below 100 = 
CALCULATE ( 
   [Measure Count],
   Table[Score] < 100 //if value is stored in % then change 100 to 1
)

[Anonymous · Accepted solution]

Hi @TXAPpdev89 

Thanks for the reply from parry2k .

You can also use the following measures.

% = 
VAR _countAll = COUNT('Table'[File #])
VAR _count = CALCULATE(COUNT('Table'[File #]), FILTER('Table', [Score] > 100))
RETURN
DIVIDE(_count, _countAll)

count = CALCULATE(COUNT('Table'[File #]), FILTER('Table', [Score] <= 100))

Output:

Best Regards,
Yulia Xu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k · Accepted solution]

@TXAPpdev89 

Measure Count = COUNTROWS ( Table )

Measure Count Above 100 = 
CALCULATE ( 
   [Measure Count],
   Table[Score] > 100 //if value is stored in % then change 100 to 1
)

Measure Count Below 100 = 
CALCULATE ( 
   [Measure Count],
   Table[Score] < 100 //if value is stored in % then change 100 to 1
)

[parry2k]

@TXAPpdev89 explain this "calculate the % of rows"

[TXAPpdev89]

Perhaps calling it % of instances or entries in that column (Score column) what % is equal to or greater than 100%