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.
Hi All,
New to BI and am struggling with the syntax for a measure.
Table = Investigations
Field 1 = Locality
Field 2 = Count of Investigations
The visual gives me a count of investigations by Locality (all good)
What I want is the same information but in a measure for each Locality, i.e.
Location A = 30
Location B = 22
Location C = 12
In the grander scheme I want to be able to work out how many investigations each locality has had by "per 100 staff", but one step at a time!
Appreciate any support
KD
Solved! Go to Solution.
Hi @KevDavies
Create a new measure like
Measure = COUNT('Table'[Investigations])
or
Measure = COUNTROWS('Table')
The 'Table' here refers to the table you use.
Hi @misaki233
Thanks fot eh suport, getting the information in the visual is not the problem, I need it in a measure so I can make other calculations based on the individual localities.
Regards
KD
Hi @KevDavies
Create a new measure like
Measure = COUNT('Table'[Investigations])
or
Measure = COUNTROWS('Table')
The 'Table' here refers to the table you use.
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 |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |