Forum Discussion
Anonymous
6 years agoNot applicable
dax help
- hi , I need count of my bidc column where "all units usa" measure is greater than 10. I am not able to write measure inside a calculate function as filter. =Calculate(count(da...
Greg_Deckler
Community Champion
6 years agoAnonymous -
Try something like:
Measure = COUNTX(FILTER('Table'[all units usa] > 10),[dac])
or
Measure = CALCULATE(COUNT('Table'[dac]),FILTER('Table'[all units usa] > 10))
If that does not help, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
Anonymous
6 years agoNot applicable
no..its not working...