Forum Discussion

I_miss_tableau's avatar
I_miss_tableau
Helper I
2 years ago
Solved

Exclude outliers based on numeric paramater

Hi, I am absolute beginner if it comes to Power BI (as my name says I used to use Tableau). I'm trying to create dashboard which exlude outlers based on user selection. User can choose value which he...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi  I_miss_tableau 

     

    Try the following DAX

    Measure = CALCULATE(SUMX(FILTER('Table','Table'[Sales]<='Table'[Paramater]),'Table'[Sales]))

     

    This is the result you want

     

     

     

    Best Regards,

    Jayleny

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi  I_miss_tableau 

 

Try the following DAX

Measure = CALCULATE(SUMX(FILTER('Table','Table'[Sales]<='Table'[Paramater]),'Table'[Sales]))

 

This is the result you want

 

 

 

Best Regards,

Jayleny

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

I_miss_tableau's avatar
I_miss_tableau
Helper I
2 years ago

Thank you again but I have another question. It helped but in my dashboard I have another measures and I want to exclude all persons which exceed outliers (filter them out from all calculations, if possible from whole database). For now it changes Sales>90 to 0 but if I want to have other measures like e.g. hours then I need to create other calculations. I wish to have column like Ex.outliers: trie/false and remove these people from my database. Hope it makes sense