Forum Discussion

Darko_Giac's avatar
Darko_Giac
Helper II
7 years ago
Solved

Splitting a Population by Demographics into Two Studies

I have what may be a bit of a tall order issue, and not sure whether it goes beyond the scope of this thread, but thought I would give it a shot.   I’m currently working that includes respondent ID...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Darko_Giac 

    Open Edit queries, add a index column from 1

    Close&&apply

    Create measures

    Median = CALCULATE(MEDIAN([Index]),ALLSELECTED(Sheet1))

result final = IF(MAX([Index])<[Median],"Study 1","Study 2")

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi Darko_Giac 

Is this problem sloved? 
If it is sloved, could you kindly accept it as a solution to close this case?
If not, please let me know.
 
Best Regards
Maggie