You know what's better than Power BI measures? More Power BI measures, in
this video I talk about measures and a subtle but important concept of implicit
versus explicit measures. Keep watching, I love measures so much I just can't
stop talking about them. So here we are talking more about measures. So I'm going
to get rid of this and let's talk about sales amount. So sales amount is doing
your calculation and I could define a measure for that, right? So sales amount,
this is just a column this came with my data set in the sales table. So
let's go here and I'm going to copy this over just control-c control-v and I'm
going to delete this one and instead I'm in the sales table, great and I'm going
to go to modeling tab and define a new measure. I'm just going to call it sales
let's zoom into that.
Sales is the sum of sales amount. That's great and I hit enter and my measure has
been created now if you didn't notice it already, notice that how it has these
different icons. Let's try again, it has these different icons. Measures have this
small calculator icon I love it, it just tells me what those are because hey, I
love measures. So I want to spot my friends wherever, wherever I can see and
this one is a calculated column I don't really care too much about those, I've
made that clear. But yeah measures, measures are cool. So
we've defined a sales measure which is simply a sum of sales amount.
Let's check the formatting as well. I'm going to change it to zero decimal place
and I'm going to add it to this table with a sorting by, see it's perfect. So
you can see that these two look alike they have the same results but I'll tell
you what's happening under the covers. So this one is an explicit measure this is
something you define explicitly and this one is an implicit measure so when you
drag a numeric column or even a non numeric you can at least do a count on
that but for a numeric column you can just drag the column in here and then if
it's numeric then it's going to let you not only pick some of these things but
also define quick count. I'm not going to go there now but yeah you can do some
things like that. What's happening under the covers you don't see it but it's
actually defining this calculation for you. This sum of sales amount there's
something under the covers which is defining that formula you just don't see
it and that's why it's implicit it's implied. I'm not a big fan of implicit
measures either, right and it has to do with reuse if I define
my own measures I like using them and built as building blocks simple measures.
I use combine them to build more complex measures and I combine the more complex
measures to define even more awesome measures. Yes not complex is awesome.
Right, so it's about reuse it's about control I can I can set the formatting
and I can set other attributes. Hey, keep watching more videos and keep
learning Power BI. But if you did enjoy this video I would love to hear from you.
So leave a comment, like, subscribe, all the good stuff. Power on my friends.