Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

See DAX expression for field that I drag onto visual and change to "Show as % of Column Total"

Hi,

 

I am a DAX newbie and would like to get a jump by seeing if there is a way to see what the DAX expression was for a simple field like Sales that I drop into a matrix would be if I change sales to be % of Column Total?

1 ACCEPTED SOLUTION

if it is a measure or a computed column then the definition will show when you click on the field in the field list on the far right.

 

In some cases built-in functions are used (like percent of grand total) - you won't see the DAX for that.

View solution in original post

3 REPLIES 3
Tahreem24
Super User
Super User

Could you please share your input data and expected output?/

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard
Anonymous
Not applicable

@Tahreem24 

 

I simply want to know what the DAX is on the second column here is so that I can create another measure that compares this number to another measure for the same row in this maxtrix.

 

Annotation 2020-06-12 172753.png

 

if it is a measure or a computed column then the definition will show when you click on the field in the field list on the far right.

 

In some cases built-in functions are used (like percent of grand total) - you won't see the DAX for that.

Helpful resources

Announcements
September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Top Solution Authors