Counting of Answer Using Measure

[jaime-aaron]

Good day!

Im currently checking if how to count how many '5' and '4' are there per line item?  Below is the sample file as reference:

What measure to use for this scenario? Thanks in advance!!

[v-jiascu-msft]

Hi @jaime-aaron,

Do you mean counting items of each columns contained numbers? Take the fifth column "Attended" for example, the measure could be like it below. Then you can write the similar measure for other columns.

Measure_Attended =
CALCULATE ( COUNT ( Table5[Attended] ), 'Table5'[Attended] IN { 4, 5 } )

Best Regards,

Dale

[jaime-aaron]

I tried to re-create the formula (mCount = CALCULATE ( COUNT ( Inpatient[m_Mean] ), 'Inpatient'[m_Mean] IN {4,5} )) however it does not display the answer,see below:

Im checking as to how it can display/count the number 4 and 5.

Thanks! 

[v-jiascu-msft]

Hi @jaime-aaron,

Can you share the pbix file? The m_Mean column didn't in the snapshot of your first post. 

Best Regards,

Dale