Forum Discussion

csaethre19's avatar
csaethre19
Icon for Helper II rankHelper II
3 years ago
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...
Need Help
  • NaveenGandhi's avatar
    NaveenGandhi
    3 years ago

    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




NaveenGandhi's avatar
NaveenGandhi
Icon for Memorable Member rankMemorable Member
3 years ago

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


csaethre19's avatar
csaethre19
Icon for Helper II rankHelper II
3 years ago

Okay. Can you maybe point me in the right direction on how to accomplish a failure rate measure?

So far I have these measures: 

Measure_FailureCount = COUNT('public failure'[Failure Mode])
 
and 
 
Measure_TotalRuns =
CALCULATE(
    DISTINCTCOUNT('public failure'[experimentId]),
    REMOVEFILTERS('public failureMode'[Failure Type], 'public failureMode'[Designation])
)
 
I need a third measure to calculate the failure rate based on these two measures.
I have this:
Measure_FailureRate = [Measure_FailureCount] / [Measure_TotalRuns]
 
However, when I graph this failure rate vs. Experiment Start Time on a line chart and set the Legend to Failure Mode I get incorrect values. It appears to be dispalying just the Failure Count multiplied by 100. It does not consider the divide by total runs per day. 
Here are some screenshots of some data I am looking at:

 

 

As you can see from the table on May 1st I should show 20% for the failure mode in blue.


 

 
  • NaveenGandhi's avatar
    NaveenGandhi
    Icon for Memorable Member rankMemorable Member
    3 years ago

    csaethre19 

    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