Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have two calculated columns:
Solved! Go to Solution.
@csaethre19
I understood you wanted the overall for a day, Just do the below changes to the measures.
TotalRuns_Test =
CALCULATE (
DISTINCTCOUNT ( 'Test'[Experiment Id] ),
ALLEXCEPT ( Test, Test[Experiment Start Time] )
)
Regards,
Hello @csaethre19
Calculated columns cannot alter its calculation based on a slicer from report view. Create these same calculations as measure. That will work fine.
Let me know if this helps!
If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!
Okay. Can you maybe point me in the right direction on how to accomplish a failure rate measure?
So far I have these measures:
As you can see from the table on May 1st I should show 20% for the failure mode in blue.
Can you provide sample data to understand the problem better, please make sure you include all the columns that will be required for calculation and visualisation.
Regards,
Naveen
https://drive.google.com/file/d/10tOYSEt6w-_WfEBi6L-oaamE1il9c6ws/view?usp=sharing
I have shared the .pbix file that is a simple idea of what I am trying to do. When setting the legend on the failure rate graph to failure mode you get incorect rates for each mode on each day. Something similar is happening in my real data set when I have these same measures.
@csaethre19
Check the attached PBIX. I have made a test table( Just to alter the data points little bit to show variation in the chart) and a test page with the line chart. Use the Failure_Rate_Test measure that i have created as it will give the desired output.
Let me know if this helps and if any questions!
If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!
Thank you for taking the time to provide this sample. However, it still does not acheive the desired results. If you look at the failure counts in the table you see that the overall failure rate is what the failure rate column is telling you but when you look at the graph you can see that the overall rate is given to two different failure modes. What I would expect is that the two failure modes for that day would show their individual failure rate. For instance, on May 04 there was a total of 4 failure counts - 1 for mode1 and 3 for mode3. The total runs for that day was 6 so for mode1 the failure rate should be 1/6 and for mode2 it should be 3/6. These two failure rates make up the 66.67% that is shown for both of these modes on the graph.
@csaethre19
I understood you wanted the overall for a day, Just do the below changes to the measures.
TotalRuns_Test =
CALCULATE (
DISTINCTCOUNT ( 'Test'[Experiment Id] ),
ALLEXCEPT ( Test, Test[Experiment Start Time] )
)
Regards,
thank you thank you thank you!!!
User | Count |
---|---|
126 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |