Out of touch DAX question

[Zsolt_Kralik]

Hi all, I'm curious about your opinion. In my reporting I've noticed, that quite a good portion of what is required can be done with simple filtering and there is no need for DAX measures.

For example, ALLSELECTED is a quite complex formula. Here is my DAX code which works as intended.

SalesQuantity_PCT_Allselected =

DIVIDE (

    SUMX ( 'Sales by Store', 'Sales by Store'[quantity_sold] ),

    SUMX ( ALLSELECTED ( 'Sales by Store' ), 'Sales by Store'[quantity_sold] )

)


But I can get the same results by using an implicit measure percent of grand total of quantity_sold.
What is the point of the effort, do you think expanding the implicit measures funcionality and quick measures feature would reduce the need for DAX?
TY.

[Zsolt_Kralik]

Hi Felix,
Thank you for the references. This post was a bit of a rant, I think there is more potential in the implicit measures given that they are quick and easy to create. I would like to see from Microsoft more options in that regard.
All your points are valid, thank you for your time.

BR,
Zsolt

[MFelix · Accepted solution]

Hi @Zsolt_Kralik,

You refer a couple of different aspects, but I believe that your main question is around the usage of implicit vs explicit measures, although the result is the same in this case, using the implicit measures is very limited because you can only use the options that Power BI gives you sum, max, min, ... and there is no option to change context or other aggregations that you may need.

There is also a couple of things on using the implicit measure that you won't be able to do for example the usage of calculation groups or field parameters, the resusiility is also a big plus for the explicit measures.

See a coulple of articles on this:

https://radacad.com/explicit-vs-implicit-dax-measures-in-power-bi

https://data-mozart.com/understanding-explicit-vs-implicit-measures-in-power-bi/

https://www.ehansalytics.com/blog/2023/9/29/always-use-explict-measures-wait-what-is-an-explicit-mea...

Concerning the Quick measure that you refer that is the creation of DAX measures in an automated way so when using that feature you will be using explicit measures.