Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |