Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!!
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
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!
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
User | Count |
---|---|
90 | |
74 | |
67 | |
63 | |
55 |
User | Count |
---|---|
102 | |
93 | |
73 | |
60 | |
59 |