Forum Discussion
Count based on revenue amount
Hi Anonymous
Assuming Amount is a physical column in your table, the measure would be
CALCULATE ( DISTINCTCOUNT ( 'table'[desc] ), keepfilers ( 'table'[amount] ) <= 5 )But youre expected result is confusing thouugh. I thought you wanted the distinct count which means that each value in desc should only be counted once - C has 2. If you mean to say the count of records, use:
CALCULATE ( COUNTROWS ( 'table' ), keepfilers ( 'table'[amount] ) <= 5 )Just change <= to > for a different calculation.
Super UserHi Anonymous
Assuming Amount is a physical column in your table, the measure would be
CALCULATE (
DISTINCTCOUNT ( 'table'[desc] ),
keepfilers ( 'table'[amount] ) <= 5
)
But youre expected result is confusing thouugh. I thought you wanted the distinct count which means that each value in desc should only be counted once - C has 2. If you mean to say the count of records, use:
CALCULATE (
COUNTROWS ( 'table' ),
keepfilers ( 'table'[amount] ) <= 5
)
Just change <= to > for a different calculation.
It doesn't works...
Let me clarify , I've 50 million rows so i have summarized table in PBI, you can see sample below.
I need classifcation <5, >5 based on description count & sales.
we need the result based on the input 'summarize table' . suggest on DAX
tried measurement
Test = COUNTAX('table',[amount]>5)
example : sum table in PBI
| Desc | Amount |
| A | 10 |
| B | 4 |
| C | 5 |
| D | 3 |
| C | 2 |
result :
| desc | <=5 | >5 |
| a | 1 | |
| b | 1 | |
| c | 2 | |
| d | 1 |