The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
I want to ask how the expression below
If I have a table
100
0
0
100
100
100
N / A
The calculation is:
1 Count 100 how many (A)
2 Count 0 how many (B)
X = A / (A + B)
The above example is: X = 4/6 X = 0.667
Thank you
Anto
Solved! Go to Solution.
Hi @Anonymous ,
Use DIVIDE so you do not get an error if happen to divide by zero.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Count 2 = Calculate (COUNT('Table'[Column1]),'Table'[Column1]=100) Count zero = CALCULATE(COUNT('Table'[Column1]),'Table'[Column1]=0) Percentage of Count = DIVIDE([Count 2],([Count 2]+[Count zero]))
Proud to be a Super User!
Hi @Anonymous ,
Use DIVIDE so you do not get an error if happen to divide by zero.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Count 2 = Calculate (COUNT('Table'[Column1]),'Table'[Column1]=100) Count zero = CALCULATE(COUNT('Table'[Column1]),'Table'[Column1]=0) Percentage of Count = DIVIDE([Count 2],([Count 2]+[Count zero]))
Proud to be a Super User!
How can I group this by date, day of week
Thank You
User | Count |
---|---|
15 | |
12 | |
8 | |
7 | |
7 |
User | Count |
---|---|
24 | |
21 | |
12 | |
10 | |
7 |