Forum Discussion
Calculating rowcount when column values are greater than or equal to selected slicer value
- Anonymous3 years ago
Hi JL83 ,
The following DAX might work for you:RowCount = CALCULATE( COUNTROWS('UnitsSold'), FILTER( 'UnitsSold', 'UnitsSold'[Sold] >= MIN('T-Slicer'[Value]) ) )The slicer I create is just like this:
Users can choose all integers between 0 and 100.
And the final output is shown in the following figure:
If I choose 4, there are 8 rows with Sold values greater than 4, so the value returns 8.Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi JL83 ,
The following DAX might work for you:
RowCount =
CALCULATE(
COUNTROWS('UnitsSold'),
FILTER(
'UnitsSold',
'UnitsSold'[Sold] >= MIN('T-Slicer'[Value])
)
)The slicer I create is just like this:
Users can choose all integers between 0 and 100.
And the final output is shown in the following figure:
If I choose 4, there are 8 rows with Sold values greater than 4, so the value returns 8.
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- JL832 years agoFrequent Visitor
Thank you for the response.
this works.