In my Power BI project, I have a simple data source that has 10 measures calculated from six regular columns. I also have this very simple query in DAX to evaluate the table:
EVALUATE TOPN(100, 'mytable')
When this query runs, only the natural columns are shown. None of the measures are shown. I have double checked to make sure that the measures are visible. They are not marked as hidden. So I don't understand why I can't see the measures.
Ideas?
Measures are logical representation in DAX queries. In order to view the measures we need to explicitly mention the DAX query like below.
EVALUATE
SUMMARIZE(
'mytable',
'mytable'[Column1],
'mytable'[Column2],
'mytable'[Column3],
'mytable'[Column4],
'mytable'[Column5],
'mytable'[Column6],
"Measure1", [Measure1],
"Measure2", [Measure2],
"Measure3", [Measure3],
"Measure4", [Measure4],
"Measure5", [Measure5],
"Measure6", [Measure6],
"Measure7", [Measure7],
"Measure8", [Measure8],
"Measure9", [Measure9],
"Measure10", [Measure10]
)