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'm new to Power BI and I'm struggeling with my first visual/report.
I have a table 'Carts' like this:
OrderId | Date |
0 | 8-11-2016 14:23:45 |
0 | 8-11-2016 14:23:45 |
1234 | 8-11-2016 14:23:45 |
5678 | 7-11-2016 14:23:45 |
0 | 7-11-2016 14:23:45 |
4521 | 7-11-2016 14:23:45 |
7896 | 7-11-2016 14:23:45 |
0 | 7-11-2016 14:23:45 |
Now I want a visual of the daily percentage with OrderId <> 0
8-11 33.33%
7-11 60.00%
How do I do this?
Solved! Go to Solution.
You can achieve this with COUNT functions. OrderID field data type must be Text for this solution to work
Create below 3 measures to achieve the desired results.
Step1:
TotalRows:= COUNTROWS(Table1) This will count all the rows in the table.
Step2:
Allrows Greater than Zero:=CALCULATE(COUNTA(Table1[OrderId]),Table1[OrderId]>"0")
Step 3:
Dailypercentage:=DIVIDE([Allrows Greater than Zero],[TotalRows],2)
You can achieve this with COUNT functions. OrderID field data type must be Text for this solution to work
Create below 3 measures to achieve the desired results.
Step1:
TotalRows:= COUNTROWS(Table1) This will count all the rows in the table.
Step2:
Allrows Greater than Zero:=CALCULATE(COUNTA(Table1[OrderId]),Table1[OrderId]>"0")
Step 3:
Dailypercentage:=DIVIDE([Allrows Greater than Zero],[TotalRows],2)
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 |
---|---|
106 | |
105 | |
79 | |
69 | |
62 |
User | Count |
---|---|
143 | |
104 | |
103 | |
82 | |
70 |