Forum Discussion

jaime-aaron's avatar
jaime-aaron
Frequent Visitor
8 years ago

Counting of Answer Using Measure

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...
Reports
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

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 } )

Counting_of_Answer_Using_Measure

 

Best Regards,

Dale

jaime-aaron's avatar
jaime-aaron
Frequent Visitor
8 years ago

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's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    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