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,
You may download my PBI file from here.
Hope this helps.
Hi,
The Excel file is not helpful - it just has all hard coded figures. Furthermore, as per your image in the previous post, the value in cell G11 should be 0 but in your Excel file it is 850 (which matches with my formula's result). Also, in your base data (Table named Append1, for 3899 > 234 > 3, there is no status as closed). Am quite confused.
Hi,
Share the raw data
del
Hi,
You may download my PBI file from here.
Hope this helps.
how can I sum the total to show
Hi,
You may download the PBI file from here.
Hope
Hi,
So will the status field be dragged in the visual?
no data
Hi,
The Excel file is not helpful - it just has all hard coded figures. Furthermore, as per your image in the previous post, the value in cell G11 should be 0 but in your Excel file it is 850 (which matches with my formula's result). Also, in your base data (Table named Append1, for 3899 > 234 > 3, there is no status as closed). Am quite confused.
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 |
---|---|
112 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |