Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

column value comparison in Power BI

Hi,   I have created a Histogram and Normal distribution curve in Power BI. I want to show the Mean value in the graph. I have created a below formula: μ = IF('DISTRIBUCION NORMAL'[X]=ROUND([Mea...
Need Help
  • parry2k's avatar
    parry2k
    6 years ago

    Anonymous are you adding μ as column, it should be measure:

     

    μ = IF(MAX('DISTRIBUCION NORMAL'[X])=ROUND([Mean_Age],0),[f(x)],0)

     

    Ask anything Power BI. Book appointment for a free consultancy at https://www.perytus.com

     

parry2k's avatar
parry2k
Super User
6 years ago

Anonymous are you adding μ as column, it should be measure:

 

μ = IF(MAX('DISTRIBUCION NORMAL'[X])=ROUND([Mean_Age],0),[f(x)],0)

 

Ask anything Power BI. Book appointment for a free consultancy at https://www.perytus.com

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi parry2k ,

 

Is there any way we can show 'Mean_Age' on the Data label? Currently, it is not showing the Mean value  (14) on the label.

 

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    Anonymous it should if you have data labelled turned on.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi parry2k ,

      If I turn on the label, it shows f(x)  value as 'μ_measure' returning that value.