Forum Discussion
DAX
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.
2 Replies
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.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
