cancel
Showing results for
Did you mean:
Helper II

## Applying 1 row value for all rows.

Table that shows answers for question of a people:

 _person.id_ question_ answer_ gender 1 gender? male male 1 age? 18 male 1 married? no male 2 gender? female female 2 age? 36 female 2 married? yes female

So, from 1 question we can now know the gender, but I need to see this person's gender in each row related to this person by his/her id. What's the formula for that? Thanks in advance!

2 ACCEPTED SOLUTIONS
Solution Sage

Hi @Gleb ,

Here you go :

__gender =

CALCULATE(
FILTER(
ALLEXCEPT(Gender,Gender[_person.id_]),
Gender[question_] = "gender?"
)
)

Kind regards,

Rohit

Community Support

Hi, @Gleb

You can try the following methods.

Measure:

Measure =
CALCULATE (
FILTER (
ALL ( 'Table' ),
[_person.id] = SELECTEDVALUE ( 'Table'[_person.id] )
&& [_question] = "gender?"
)
)

Column:

gender =
CALCULATE (
FILTER (
'Table',
[_person.id] = EARLIER ( 'Table'[_person.id] )
&& [_question] = "gender?"
)
)

Does it match the output you expect?

Best Regards,

Community Support Team _Charlotte

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

4 REPLIES 4
Community Support

Hi, @Gleb

You can try the following methods.

Measure:

Measure =
CALCULATE (
FILTER (
ALL ( 'Table' ),
[_person.id] = SELECTEDVALUE ( 'Table'[_person.id] )
&& [_question] = "gender?"
)
)

Column:

gender =
CALCULATE (
FILTER (
'Table',
[_person.id] = EARLIER ( 'Table'[_person.id] )
&& [_question] = "gender?"
)
)

Does it match the output you expect?

Best Regards,

Community Support Team _Charlotte

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

Solution Sage

Hi @Gleb ,

You can do this using Power Query.

In the first step, please add a conditional column as shown below :

You will see a new column added with gender values and nulls.

In the next step, click on the _gender column, go to "Transform" --> "Fill" --> ''Down"

This will give you the result as expected

Kind regards,

Rohit

Helper II

I can't use edit query for this table, I need a dax code

Solution Sage

Hi @Gleb ,

Here you go :

__gender =

CALCULATE(
FILTER(
ALLEXCEPT(Gender,Gender[_person.id_]),
Gender[question_] = "gender?"
)
)

Kind regards,

Rohit

Announcements

#### The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

#### Ted's Dev Camp - July 28, 2022

Watch Session 24 of Ted's Dev Camp along with past sessions!