Forum Discussion
Poor Measure Performance and Confusion
I have simple data model shown below. The notable point is that the dimension table has 3.5m rows of data (a list of engagement codes). I would like to generate a table visual that looks lik...
Hey vgeldr,
Maybe try:
FirstMonth =
VAR Filtered =
CALCULATETABLE (
VALUES ( 'CTE YTD Excel Report (ServiceNow)'[Usage Month] ),
ALLEXCEPT ( 'CTE YTD Excel Report (ServiceNow)'[GPN] )
)
VAR Result =
MINX (
Filtered,
'CTE YTD Excel Report (ServiceNow)'[Usage Month]
)
RETURN
Result
----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)
