Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Percentile over dynamic selection

Hello..
I have 2 tables
1-member
2-members Income Source
The first one contains data about member itself.. And every row define a unique person
The second one contains member income sources.. So the member may be repated 100 or what ever each row define income source and value for 1 person....
So i want to find total income for people below 10%... What i did that i created a calculated column in members table
{ total income= sum(income)} from the income table
Then measure =calculate(sum(income),
Total income<percentile.Exc(total income)

This works great but for total calculated column... Sometimes the statistcal need to filter an income source from income table .. Then the total income calculated column will not be filtred.. However my measure too... Is there anyway to calculatr my percentile on total income for income sources that the end user choose from slicer or whatever filter...
Thank you

2 Replies

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar

    Hi Anonymous ,

    To understand your scenario better, please share the data sample which could reproduce your scenario and your desired output so that we could help further on it.

    Please refer to this blog how to answer your question quickly.

    Best Regards,

    Cherry

     

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar

    Hi Anonymous ,

    Have you solved the problem?

    If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

    If you still need help, please feel free to ask.

    Best  Regards,

    Cherry