Forum Discussion
How does Analyze data create measures ?
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 ?
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.
2 Replies
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.
That's what I thought, there is no way to replicate that without creating a new measure. Thank you !
