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
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
thank you thank you thank you!!!