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 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 @prajanto ,
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 @prajanto ,
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
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 |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |