Forum Discussion
Chaitanya_malir
Helper I
Helper IDAX
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 , 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.
amitchandak
Super User
Super UserChaitanya_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.