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.
Good morning, I have built a measure to calculate the counts of issues in total by issue type.
Solved! Go to Solution.
Hi , @Sonia316
I'm so sorry , i still can not understand the logic for the sample data.
Where is the [Color WidthBottom]? And which field to check the color? And what is the meaning of the "count of each time something is red by line in the last 24 hours"?
"in the last 24 hours", i can not see the Date/Time column to judge the times. And in the result table , i seems the red text return '1' and the yellow text return BLANK(). But it has no field to judge the text color.
Can you explain more detailed for your logic you want to me? I am very confused now.
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Not exactly, but I like this one and I may use it as well. That count is a cumulation of each line that is running at the plant. I want to break it down by line.
So let's say line 201, 202, 203, 204 and 205 all have 3 reds in the last 24 hours (rolling-that part I already have figured out), I was hoping to have the main one that says how many total, like I did and then do another that actually breaks it all down.
Hi, @Sonia316
Hi, i have no your sample data and your table relationship. i am not fully understanding your end result you need. It seems like a dax question . Can you share some sample data as a table and the end result you want as a table according to the sample data to us so that we can help you better!
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Line | Width | WidthTop | WidthBottom | ||
201 | 5.550 | 5.570 | 5.570 | ||
202 | 5.550 | 5.570 | 5.560 | ||
203 | 5.550 | 5.579 | 5.570 |
So I would like to count of each time something is red by line in the last 24 hours.
So I should end up with
Line | Width | WidthTop | WidthBottom |
201 | 1 | 1 | |
202 | 1 | ||
203 | 1 | 1 |
Hi , @Sonia316
I'm so sorry , i still can not understand the logic for the sample data.
Where is the [Color WidthBottom]? And which field to check the color? And what is the meaning of the "count of each time something is red by line in the last 24 hours"?
"in the last 24 hours", i can not see the Date/Time column to judge the times. And in the result table , i seems the red text return '1' and the yellow text return BLANK(). But it has no field to judge the text color.
Can you explain more detailed for your logic you want to me? I am very confused now.
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
I already have the charts done by 24 hours. I originally attached my PBIX file on the original thread. I just need to know how to do BY LINE. I already have the counts as a whole, I just need to do the breakdown.
Hi, @Sonia316
According to your dax expression, you calculate the count of the [Color WidthBottom]="Red"> right?
Do you mean you want to show the different [Color WidthBottom] count in your line chart?
If this , you can put the [Color WidthBottom] in the "Legend".
And you can just use this measure :
Measure = COUNTROWS('Table')
Then we can get the different count group by [Color WidthBottom].
If this method does not meet your needs, you can provide us with your special sample data and the desired output sample data in the form of tables, so that we can better help you solve the problem.
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
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 |
---|---|
96 | |
93 | |
83 | |
70 | |
65 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |