Forum Discussion
Solved
Calculated Columns Affected By Slicer Filters
I have two calculated columns: CalculatedColumn_FailureCount = CALCULATE( COUNTROWS('public failure'), ALLEXCEPT('public failure', 'public failure'[Failure Mode], 'public failure'[Exper...
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] )
)FailureRate_Test = [FailureCount_Test] / [TotalRuns_Test]
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
can you provide access for the file.