Forum Discussion
Solved
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 ...
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.
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 !