Explicit Vs Implicit DAX Measures in Power BI

Have you ever tried to connect to a Power BI dataset from Excel using Analyze in Excel? if yes, you might have had this experience that your values don’t show in Excel’s Pivot table as values. This is because those values are not explicit measures, they are implicit measures in Power BI. In this article and video, I’ll explain the difference between these two types of measures in Power BI and the impact on the user.
learn more from my blog article here:
radacad.com/ex...
*******************
Want to learn about Power BI or AI? or take your Power BI and AI knowledge to the next level for building reports? Check out our courses in RADACAD Academy for all aspects of Power BI and AI.
RADACAD courses: radacad.academy
Our upcoming courses: learn.radacad....
Free books and tools for Power BI: radacad.com
Power BI Helper: powerbihelper....
Become an academy member: learn.radacad....
*******************
********
CONNECT with US!
********
-- / radacad_com
-- / rad_reza
-- / leila_etaati
-- / radacad
-- / leila-etaati-b0304636
-- / rezarad
-- / 6393399
-- radacad.com
********
#PowerBI #PowerBIfromRookieToRockStar #PowerQuery #DAX #Visualization #RADACAD

[@srinivaskandru5034]

Probably I been have thinking about this since 2014 everywhere...in toilet, in bus, while playing my badminton etc....why can't i use implicit measures when both looks same..now I got the answer

[@yichen5142]

Encountered columns couldn't apply in value field issue after calculation group has been enabled, using explicit measures solve this issue. Thank you for the great explanation.

[@RonaldPostelmans]

Perfectly clear explination

[@wout_s]

Very clearly explained, thank you!

[@zhuangzhiyuan]

Thank you so much for your well explained and very clear summarized video.

[@RADACAD]

You are welcome!

[@irynavilner4533]

Thank you! Great explanation!

[@kpieceemmry3387]

In other to understand implicit measures accurately, how the the Totalsales find itself in the data field for it to be available for dragging? How is it first created before available for dragging?

[@kpieceemmry3387]

Thanks for this video
What do you mean by showing visualizations of sum of sale by English education? And is setting aggregation in one makes it different from another?

[@sachinthakkar4131]

Well described - thank you.

[@RADACAD]

Glad it was helpful!

[@chetanjagtap8237]

good explaination

[@bithepower9081]

Thank you very well explained

[@americanstudies1934]

Ata?

[@beforetherainstops1553]

Excel will support Implicit soon

[@RADACAD]

Yes. looking forward to it.