Reply
Member
Posts: 79
Registered: ‎02-02-2019
Accepted Solution

RE: show measure values in %

Hi all,

 

i have used few measures in matrix table

 

but that measures  i need to show as % values .. 

i used below measure for example   but result values coming as  0.01 

 

TCV(HW)Margin% = sum(vw_daas_Total_Contract_Value_Orders[Total_Contract_Value_Hardware_Margine])/sum(vw_daas_Total_Contract_Value_Orders[Hardware_Total_Contract_Value])
 
per.PNG

Accepted Solutions
Super User
Posts: 2,846
Registered: ‎09-27-2017

Re: RE: show measure values in %

@Chanty4u

 

This is the VISUALIZATIONS section.

There is another section beside it called "FIELDS" section.

 

Select the MEASURE from there

chanty.png

View solution in original post


All Replies
Highlighted
Regular Visitor
Posts: 47
Registered: ‎05-15-2018

Re: RE: show measure values in %

[ Edited ]

Select the measure (under Fields), go to Modeling Tab from the menu, select % under the Formatting section.

 

Regards,

Tarun
Did I answer your question? Mark my post as a solution!

 

Super User
Posts: 2,846
Registered: ‎09-27-2017

Re: RE: show measure values in %

@Chanty4u

 

Just Select the MEASURE from "Fields" section >>Modelling Tab>>Formatting>>Percentage

Member
Posts: 79
Registered: ‎02-02-2019

Re: RE: show measure values in %

Hi,

 

i have tried its disabled in  modeling tab Smiley Sad

Super User
Posts: 2,846
Registered: ‎09-27-2017

Re: RE: show measure values in %

@Chanty4u

 

Did you select the MEASURE first from the "FIELDS" section?

Member
Posts: 79
Registered: ‎02-02-2019

Re: RE: show measure values in %

Hi,

 

yeah i have selected but.. its not selecting 

 

i have 3 % columns.. but im unable to select .. when i double click  its asking to rename only.p_cl.PNG

Super User
Posts: 2,846
Registered: ‎09-27-2017

Re: RE: show measure values in %

@Chanty4u

 

This is the VISUALIZATIONS section.

There is another section beside it called "FIELDS" section.

 

Select the MEASURE from there

chanty.png

Member
Posts: 79
Registered: ‎02-02-2019

Re: RE: show measure values in %

sorry my bad Smiley Sad     its found now  thanks alot Smiley Happy