Forum Discussion
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:
So when the Mean_age value matches with ''DISTRIBUCION NORMAL'[X]', it shows the f(x) value in the 'μ' column else return '0' as below:
but when I select any value from the filter, the mean value gets changed but in the 'μ' column, its not changing.
Please see the below example,
here, I selected, Emp Id 1 and 2, the mean value is: 14 but in the bar it's still showing as 29. It is not considering the filter selection and comparision is not happening.
still showing value for 29 in the data as well.
Does anyone have idea about this? Am I missing anything?
Thanks in advance.
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
5 Replies
- parry2kSuper User
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