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 am fairly new to Power BI and I need your help so I can get the final result on column "Count 1".
Basically I want to count how many "ones" are between "Action 1" and "Action 7" columns for the entire row.
Any suggestions would be much appreciated!
Thank you very much!
Example:
'Clients Actions'
Customer | Action 1 | Action 2 | Action 3 | Action 4 | Action 5 | Action 6 | Action 7 | Count 1 |
A | 1 | 3 | 3 | 1 | 2 | |||
B | 1 | 2 | 6 | 7 | 1 | |||
C | 7 | 8 | 3 | 0 | ||||
D | 4 | 7 | 1 | 2 | 1 | |||
E | 1 | 3 | 8 | 1 | 1 | 3 |
Solved! Go to Solution.
Hi @dnhmm,
Please create a calcualted column using the formula below.
Column = IF(Table1[Action 1]=1,Table1[Action 1],0)+IF(Table1[Action 2]=1,Table1[Action 2],0)+IF(Table1[Action 3]=1,Table1[Action 3],0)+IF(Table1[Action 4]=1,Table1[Action 4],0)+IF(Table1[Action 5]=1,Table1[Action 5],0)+IF(Table1[Action 6]=1,Table1[Action 6],0)+IF(Table1[Action 7]=1,Table1[Action 7],0)
You will get expected result as the screenshot shows.
Best Regards,
Angelia
Hi @dnhmm,
Please create a calcualted column using the formula below.
Column = IF(Table1[Action 1]=1,Table1[Action 1],0)+IF(Table1[Action 2]=1,Table1[Action 2],0)+IF(Table1[Action 3]=1,Table1[Action 3],0)+IF(Table1[Action 4]=1,Table1[Action 4],0)+IF(Table1[Action 5]=1,Table1[Action 5],0)+IF(Table1[Action 6]=1,Table1[Action 6],0)+IF(Table1[Action 7]=1,Table1[Action 7],0)
You will get expected result as the screenshot shows.
Best Regards,
Angelia
Many 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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |