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.
I have a SharePoint list that I'm collecting data with from an InfoPath form.
Unfortunately the list was set up to record text values (yes/ no) rather than numeric.
I need to be able to total each column where the value is 'yes'
Please see screenshot of data and the second screenshot of the desired output.
Any help much appreciated - thanks!
Desired Results:
Solved! Go to Solution.
No, just create a measure like this:
Measure = CALCULATE(COUNT([Ceremony 1]),[Ceremony 1] = "yes")
Now, if they come through as logical values into Power BI, you may have to use COUNTA instead of COUNT.
So, typically this is something like:
CALCULATE(SUM([Column]),[Another Column]="Yes")
Do i need to add the total column into my SharePoint list then to use it within Power BI?
ie. Ceremony 1 | Ceremony 1 Total | Ceremony 2 | Ceremony 2 Total | ... etc
No, just create a measure like this:
Measure = CALCULATE(COUNT([Ceremony 1]),[Ceremony 1] = "yes")
Now, if they come through as logical values into Power BI, you may have to use COUNTA instead of COUNT.
Ah I got it to work:
Ceremony 1 = CALCULATE(COUNTA('Query1'[Ceremony1]), 'Query1'[Ceremony1] = { "yes" }) Ceremony 2 = CALCULATE(COUNTA('Query1'[Ceremony2]), 'Query1'[Ceremony2] = { "yes" }) Ceremony 3 = CALCULATE(COUNTA('Query1'[Ceremony3]), 'Query1'[Ceremony3] = { "yes" })
etc...
Thanks!
Hi smoupre..
That syntax is wrong .. tried Count and CountA
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |