Create Mode Mesaure in Dax

[Anonymous]

I know this has already been covered but I can't seem to replicate what i've found on my specific data.

I have personal statistics and I would like to create a Mode for all the features such as BMI, weight, height for all our members. 

I have attached a screenshot example of my data. 

Please help!

[Anonymous]

I should point out that I have a measure, which seems to show the correct data for the attributes I have data for, but for the attributes that I have no data recorded the measure is showing data relating to other attributes and I cannot understand why. 

My measure is:

Mode BMI = 
MINX(
    TOPN(
        1,
        ADDCOLUMNS(
            VALUES('Biometrics'[Result]),
            "Mode", CALCULATE(COUNT('Biometrics'[Result]),
                    FILTER('Biometrics', '1e Biometrics'[Attribute]="BMI"))
                ),
                [Mode], 
                0
        ),      
    'Biometrics'[Result]
    )

[dax]

Hi heytherejem, 

I don't understand your requirement, you said that " but for the attributes that I have no data recorded the measure is showing data relating to other attributes and I cannot understand why"? If possibel, could you plesae inform me your detailed information(such as your expected output)? Then I will help you more correctly.

Best Regards,
Zoe Zhi

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

[parry2k]

@Anonymous hope this link helps, there is a section talks about mode