Forum Discussion
csaethre19
Helper II
Helper IICalculated 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
csaethre19Helper II
Helper IIhttps://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.
NaveenGandhi
Memorable Member
Memorable Membercsaethre19
can you provide access for the file.