How does Analyze data create measures ?

[Oimat]

Hello, 

I just found about the Analyze feature (Use the Analyze feature - Training | Microsoft Learn), so I clicked in my chart showing number of employees per month, and analyzed to explain why is it going up. And the Analyze feature showed me a bar chart with the number of employees per department from march compared to april.

In the Y-Axis the measurements are even called "Number of employees in march" and "Number of employees in april".

I do not understand how that can be possible : no new column nor measurement was added to my semantic model, and no visual calculation has been created. If I wanted to do the same (applying a filter for one Y-Axis measure while applying another filter to a seconde Y-Axis measure for example), how could I do that ?

 

[andrewsommer · Accepted solution]

The Analyze feature uses auto-generated DAX and temporary behind-the-scenes measures that Power BI creates dynamically and transiently.  They are not added to your semantic model and do not persist in your dataset.

To recreate:

[Employee Count] = COUNTROWS('Employees')

[Employees in March] = CALCULATE([Employee Count], 'Date'[Month] = "March")
[Employees in April] = CALCULATE([Employee Count], 'Date'[Month] = "April")

Or using dates you can:

[Employees in March] = CALCULATE([Employee Count], MONTH('Date'[Date]) = 3 && YEAR('Date'[Date]) = 2025)

Please mark this post as a solution if it helps you. Appreciate Kudos.

[Oimat]

That's what I thought, there is no way to replicate that without creating a new measure. Thank you !