To increment the value whenever the parameter crosses the threshold in power BI using DAX

0
votes

I am using DirectQuery in Power BI and I want to create a measure for calculating the number of occurrences a particular parameter has crossed its threshold (say 150). If it has crossed twice till now , the value should be 2. I am a newbie, if anybody could help it would be great!

The data set looks like (with threshold 150)

Parameter | Value | Count 
A         | 240   | 1
A         | 245   | 2
A         | 110   | 2
A         | 160   | 3
1
powerbidax

1 Answers

1
votes

What have you tried so far?

A simple measure like the following should give you what you need:

CALCULATE(COUNT('Table'[Value]), 'Table'[Value] > 150)