DAX Divide by 100 with a filter

[gavpop]

I'm still in the early days of learning Powerbi.  This is first time post, so I hope it makes sense.

I'm trying to create a simple divide by 100 but I keep getting the "a single value for column '***' in table '***' cannot be determined..." message.

So I'd like to filter the query but I have no idea how to do it.

Here is what I have...

Measure 2 = CALCULATE('ProjectFigures'[Revenue] = "527322") / 100

The "527322" needs to be dynamic - ie, pulled from a drill through on a previous page.

[amitchandak · Accepted solution]

@gavpop , what you want in this measure

like

 Measure 2 = CALCULATE(countrows(filter( 'ProjectFigures', 'ProjectFigures'[Revenue] = "527322")) ) / 100

or

Measure 2 = CALCULATE(Sum('ProjectFigures'[Revenue])) / 100

[mhelgeson]

This is great! Thank you, Amit! Measure 2 was very easy to implement!