Measure description in Direct Query

[Anonymous]

Hi,

when using Visual Studio Tabular model, you can add description to every measure. This allows the end user to easily understand what each measure does and give any additional information you want the user to have.

Is this possible when calculating a new measure directly from PBI report, using Direct Query (meaning no access to Model tab)?

I have some measures sitting in Tabular model with description, and some report-specific measures directly on PBI which I cannot find how to add description to.

I found this old thread saying it's a possibility under Modeling, but it works only on import:

https://community.powerbi.com/t5/Desktop/field-properties-for-Measures/td-p/321867 

Even with the new December'19 ribbon update, measure description is not an option.

Thanks!

[poddubnyoi]

Hello, 

if i correct understand your question.

In measure code you need to add something like this in a row: 

1. Measure Name = 

2. -- your description

3. Formula

4. -- your description 

Looks like this: 

[Anonymous]

Thank you for your reply.

This is a remark, that the user can see if they actually go ino the measure code.

I am looking for a description like this, available in Visual Studio and when not using Dirct Query:

[poddubnyoi]

1. Need to switch to Model mode and open second column from right "Properties" and fill with text Description field, than switch back to report list.

2. This will look like this

[Anonymous]

Thank you, but I'm asking about working in Direct Query mode.

In this mode, there is no "Model" tab.

[Icey]

Hi @Anonymous ,

It is in Relationship View.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thank you @Icey .
However Relationship view is also unavailable in Direct Query from Analysis Services.

[Icey · Accepted solution]

Hi @Anonymous ,

For SSAS, one of the connection types is called "LiveConnect".

Then, hope this post can help you: SSAS Measures definition will not appear in Power BI.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.