Thanks for posting. Just subscribed to your channel. Your outlier technique gave me an idea on how to detect differences in my accounting accruals specially on the swings of values month over month! Great channel.
Great explanation and tools!! Another interesting analysis could be the cost per sq.ft The cost could be related to the size, but looking at it as $/sq.ft might be more meaningful. I know this is just an explanation of the tools, just sharing the thought. Thank you very much for the video, it is very useful!!!
you probably dont give a shit but does any of you know a method to log back into an instagram account? I somehow forgot the login password. I would love any tips you can offer me.
@Coen Giovanni I really appreciate your reply. I found the site through google and I'm waiting for the hacking stuff now. Seems to take quite some time so I will reply here later when my account password hopefully is recovered.
To be able to use the Outlier detector, the PowerBI has to install 3 packages. But I couldn't DMwR install. So it didn't work. DmWr seems removed from R. Does this visual (Outlier detector) still work?
Hi Nathan! Great post. Just one question; I´m actually just interested in the outliers and would therefor like to use this visual as a drillthrough/ filter for another visual. So I would like to press on the datapoint of a particular outlier, so that it filters a table that is in the same page. Do you know if this is now possible? Really looking for the interaction with other visuals here...
Excellent description of Outliers. Have learnt a new stuff which will help me. Have a doubt here in the DAX you have written for ZScore. The DAX starts with ([Market Value]) which do not have a table mentioned to it. I have an exactly similar scenario which I am writing the same DAX. But unable to execute it. I get the below error: ZScore = ('PSC_Tokyo MoU'[Deficiency Count] - AVERAGE('PSC_Tokyo MoU'[Deficiency Count]))/STDEVX.S('PSC_Tokyo MoU'[Deficiency Count]) Error: Too few arguments were passed to the STDEVX.S function. The minimum argument count for the function is 2 Can you please help?
I'm sure you've worked it out by now. But it looks like you need to add the table reference to the STDEVX.S function. Maybe like this... STDEVX.S(RELATEDTABLE(PSC_Tokyo MoU), PSC_Tokyo MoU[Deficiency Count])
Hi need help on DAX,I have a data of columns names as ,student name and status(pass/fail).so need to calculate the pass% and fail% for total ppulation of students with the use of dax funftion.Can any one help me to get the dax function.
Hi Kamesh, since you already have the pass and fail status, I would do a count of each status as a separate measure and then use the measure to divide by a COUNT of all records. So one measure that counts PASS, another that counts FAIL, and then use the results as the numerator over the total count.
It's really helpful for my current situation. Now I'm learning how to to implement this into realistic job flow
Awesome to hear Casper!
Same here learning how to implement this into real business problem. 🙂
This was great. Hope to see more Power BI tips from you.
very wonderful piece. Thank you very much!
You're welcome Feng!
Excellent description of outliers...Thanks !!
Great explanation of outliers..will use this technique at work..
Thanks jazzista1967, glad to hear the explanation is useful. 😀
Thanks for posting. Just subscribed to your channel. Your outlier technique gave me an idea on how to detect differences in my accounting accruals specially on the swings of values month over month! Great channel.
Great explanation and tools!! Another interesting analysis could be the cost per sq.ft The cost could be related to the size, but looking at it as $/sq.ft might be more meaningful. I know this is just an explanation of the tools, just sharing the thought. Thank you very much for the video, it is very useful!!!
Great observation Raul! I'm glad you find the videos helpful.
Great video! Thnx
Glad you liked it!
That visual (Power Bi Outliers Detection) is not longer available in Power Bi, do you knwo why or what can I do to get it???
PD: Great video
Finally found something I understand but can't use because app no longer exist in power bi. 😭😭
Great explanation, thank you!
you probably dont give a shit but does any of you know a method to log back into an instagram account?
I somehow forgot the login password. I would love any tips you can offer me.
@Dash Byron Instablaster =)
@Coen Giovanni I really appreciate your reply. I found the site through google and I'm waiting for the hacking stuff now.
Seems to take quite some time so I will reply here later when my account password hopefully is recovered.
@Coen Giovanni it did the trick and I actually got access to my account again. I'm so happy:D
Thank you so much, you really help me out !
@Dash Byron glad I could help :D
To be able to use the Outlier detector, the PowerBI has to install 3 packages. But I couldn't DMwR install. So it didn't work. DmWr seems removed from R. Does this visual (Outlier detector) still work?
Hi Nathan! Great post. Just one question; I´m actually just interested in the outliers and would therefor like to use this visual as a drillthrough/ filter for another visual. So I would like to press on the datapoint of a particular outlier, so that it filters a table that is in the same page. Do you know if this is now possible? Really looking for the interaction with other visuals here...
How were you able to have a non-aggregated column in your measure formula ?
Outliers detection plot is not present in power bi
Excellent description of Outliers. Have learnt a new stuff which will help me.
Have a doubt here in the DAX you have written for ZScore. The DAX starts with ([Market Value]) which do not have a table mentioned to it. I have an exactly similar scenario which I am writing the same DAX. But unable to execute it. I get the below error:
ZScore = ('PSC_Tokyo MoU'[Deficiency Count] - AVERAGE('PSC_Tokyo MoU'[Deficiency Count]))/STDEVX.S('PSC_Tokyo MoU'[Deficiency Count])
Error: Too few arguments were passed to the STDEVX.S function. The minimum argument count for the function is 2
Can you please help?
I'm sure you've worked it out by now. But it looks like you need to add the table reference to the STDEVX.S function. Maybe like this...
STDEVX.S(RELATEDTABLE(PSC_Tokyo MoU), PSC_Tokyo MoU[Deficiency Count])
Can we drill through by using scatter plot
Please share the dataset file
Hi need help on DAX,I have a data of columns names as ,student name and status(pass/fail).so need to calculate the pass% and fail% for total ppulation of students with the use of dax funftion.Can any one help me to get the dax function.
Hi Kamesh, since you already have the pass and fail status, I would do a count of each status as a separate measure and then use the measure to divide by a COUNT of all records. So one measure that counts PASS, another that counts FAIL, and then use the results as the numerator over the total count.
...