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,
I've searched everywhere for this and seem unable to find an answer!
I'm wanting a measure to count the columns, in a specified range of columns, whereby the value is greater than 0. I've included an example of how this would look - The Count column is the result of the measure and, for example, column A isn't being counted as it's not relevant.
Any help would be much appreciated.
Thanks
Solved! Go to Solution.
Hi @Liam01 ,
Try something like this.
Columns Populated = VAR B_C = IF(SUM(Test[B])>=1,1,0)
VAR C_C = IF(SUM(Test[C])>=1,1,0)
VAR D_C = IF(SUM(Test[D])>=1,1,0)
VAR E_C = IF(SUM(Test[E])>=1,1,0)
RETURN B_C+C_C+D_C+E_C
Hi @Liam01 ,
Try something like this.
Columns Populated = VAR B_C = IF(SUM(Test[B])>=1,1,0)
VAR C_C = IF(SUM(Test[C])>=1,1,0)
VAR D_C = IF(SUM(Test[D])>=1,1,0)
VAR E_C = IF(SUM(Test[E])>=1,1,0)
RETURN B_C+C_C+D_C+E_C
Hi,
I'm returning to this as I need this to do something slightly different and hopefully you may be able to help.
As it works at the minute, it counts the items but if a job appears twice with a B in each occurrence, it will still only return 1.
I guess i'm wanting this measure to do a count rather than a distinct count, as in the photo below - Top table shows data, bottom shows when it's combined by job number.
So if a job appears twice and each occurrence has an A, the bottom table would show 2. Hopefully that makes sense.
Thanks
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 |
---|---|
104 | |
96 | |
79 | |
67 | |
62 |
User | Count |
---|---|
137 | |
106 | |
104 | |
81 | |
63 |