Forum Discussion

carter's avatar
carter
Frequent Visitor
9 years ago
Solved

Group before calculating the Quartiles

Hello,   I am looking to group my data by one of the columns and then calculate the IQR of a corresponding column. The goal will be to find Q1 and Q3 values for each group then use this to filter o...
Need Help
  • TomMartens's avatar
    TomMartens
    9 years ago

    Hey,

     

    I'm sorry for the delay, and I'm also sorry for mentioning it would be become a little more complex ... At least not now.

     

    I created a little pbix file, and I used the same the formula like you do, except a minor issue. Here is my formula

    summarize to percentile = 
    SUMMARIZE('samplePercentile','samplePercentile'[GroupColumn],"p", PERCENTILE.INC('samplePercentile'[Value],0.25)
    )

    And all works well, I also tried the formula on a real-life dataset, the same result, working well ...

     

    I'm wondering if your [groupedcolumn] is a measure or column in Table1

     

    So, I guess you have to share your data, being able to reproduce your issue (at least trying).

    By the way, what version of Power BI Desktop are you using.

    I'm using the latest July update: 2.48.4792.721

     

    Regards

     

TomMartens's avatar
TomMartens
Icon for Super User rankSuper User
9 years ago

Hey,

 

I'm sorry for the delay, and I'm also sorry for mentioning it would be become a little more complex ... At least not now.

 

I created a little pbix file, and I used the same the formula like you do, except a minor issue. Here is my formula

summarize to percentile = 
    SUMMARIZE('samplePercentile','samplePercentile'[GroupColumn],"p", PERCENTILE.INC('samplePercentile'[Value],0.25)
    )

And all works well, I also tried the formula on a real-life dataset, the same result, working well ...

 

I'm wondering if your [groupedcolumn] is a measure or column in Table1

 

So, I guess you have to share your data, being able to reproduce your issue (at least trying).

By the way, what version of Power BI Desktop are you using.

I'm using the latest July update: 2.48.4792.721

 

Regards

 

Brainfried88's avatar
Brainfried88
Frequent Visitor
4 years ago

Hi TomMartens , what's the difference if it was a measure or column in a table? I think I'm encountering the same thing, but in my case, I need to rely on another measure. Unable to see the pbix file now as its been removed. Appreciate any replies!