How to View DAX Querie results in a Visual

[carlton7372]

Hello Community,

I very new to Power BI. I have created the following DAX query. 

EVALUATE

    SELECTCOLUMNS(

        TOPN(

            100,

            'Item History Operation',

            'Item History Operation'[Day],

            ASC

        ),

        'Item History Operation'[Day],

        'Item History Operation'[Operations],

        'Item History Operation'[CU (s)],

        'Item History Operation'[Duration (s)],

        'Item History Operation'[Throttling (s)],

        'Item History Operation'[ItemHistoryUniquKey]

    )

    ORDER BY 'Item History Operation'[Day] ASC

The output is as follows:

Can someone let me know if it's possible to create a visual from the DAX page? Or simply from the output.

[danextian · Accepted solution]

No. The DAX Query view is supposed to be a native way to inspect the query generated by a visual for optimization or for some other purposes. 

[carlton7372]

Hi, in somewhat related question, is it possible to create a sub-folder or category under Measures? For example I would like to create a sub-category called, MyMeasures, under Measures. Is that possible?

[danextian · Accepted solution]

You can use a backslash to create  subfolder or a semicolon to assign the same measure to different folders

[grazitti_sapna]

Hi @carlton7372,

You can do that by going to Modelling tab and then select the measure which you eant to move, under properties pane, type display folder name. it'll move the measure under that folder (Folder will be created if not already exist), repeat for other measuers and they will also move to this folder 

[danextian]

Hi @carlton7372 

You either create a calcualted table from using the whole SELECTCOLUMNS in your query and add them to the a table visual or add the columns outside TOPN but inside SELECTCOLUMNS to a table visual, sort by day in descending order and add  TOPN filter on day using the visual filter. No direct way to convert a DAX query to a visual. Almost everything that happens in the report view translates to one a DAX query but it is not the other way around.

[carlton7372]

Hi Danextian,

---

@danextian wrote:

No direct way to convert a DAX query to a visual. 

This is a shame.

Is there absolutely no way of converting a DAX query into a visual?

[danextian · Accepted solution]

No. The DAX Query view is supposed to be a native way to inspect the query generated by a visual for optimization or for some other purposes. 

[carlton7372]

@grazitti_sapna Thanks for getting in touch. I tried your suggestion, but I'm getting the following error:

[grazitti_sapna]

Hi @carlton7372, 

You are creating a measure but you need to create a table by clicking new table.

[carlton7372]

Hi, thanks again for getting back to me. 

When you say 'clicking new table', did you mean

[grazitti_sapna]

Hi @carlton7372,

Click on ony table in Data pane on right side.

and select new table from table tools

[grazitti_sapna]

Hi @carlton7372,

Instead of running an EVALUATE in query view, define a calculated table in your model:

MyTable =
TOPN (
100,
SELECTCOLUMNS (
'Item History Operation',
"Day", 'Item History Operation'[Day],
"Operations", 'Item History Operation'[Operations],
"CU (s)", 'Item History Operation'[CU (s)],
"Duration (s)", 'Item History Operation'[Duration (s)],
"Throttling (s)", 'Item History Operation'[Throttling (s)],
"ItemHistoryUniquKey", 'Item History Operation'[ItemHistoryUniquKey]
),
[Day], ASC
)

Alternatively you can use the required columns in table view and add a filter with top 100 by day as below

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!

[carlton7372]

Thanks for getting in touch. I tried your suggestion, but I'm getting the following error: