Forum Discussion

VoskaNova's avatar
VoskaNova
Frequent Visitor
7 years ago

Count on a measure?

Hello, Having the hardest time trying to figure out a solution for this.  My customer wants a count of the number of people meeting a metric.   I have the data currently in a matrix like: T...
Need Help
v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
7 years ago

VoskaNova,

 

You can convert the measure MetricCount into a calculate column and then create a measure like pattern below:

 

Result =
CALCULATE (
    SUM ( 'Closures&SettlementsFinal'[MetricCount] ),
    ALLSELECTED ( 'Closures&SettlementsFinal' )
)

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.