DAX

[Chaitanya_malir]

Hi Guys,

I need to count how many times a value reaching particular value.

Example: In above table lets say Consider i want to  caluclate a particular "Fault ID(dec)" reaching 100% merit ID

[Chaitanya_malir]

yes  @amitchandak 

Sorry Actually it is difficult share sample file because there are multiple files i have to share . but  i got some info from your answer. Thanks for your Help

[amitchandak · Accepted solution]

@Chaitanya_malir , Not very clear.

Countx(filter(Table,[merit ID Dec] >100), [Fault ID Dec])

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Appreciate your Kudos.