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 advance!!

Reports

3 Replies

  • 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