Using %GT columns in Measures

Question

&nbsp;Hi all,&nbsp;I'm trying to create a measure which performs :&nbsp;Estimated OEE&nbsp; x&nbsp; % Time&nbsp;%Time is de %GT representation of the 'Estimated time'column using the 'show value as' function&nbsp;&nbsp;&nbsp;Can I do this in DAX ?

amitchandak · Answer

RikMertens , A measure like
[Estimated OEE]*divide([Estimated time], calculate([Estimated time],allselcted(Table)))

rikmertens · Answer

Hi&nbsp;amitchandak&nbsp; i've got the measure working, thanks! However, the total row now applies the same measure, i would like to see the SUM of the calculated column 'Weighted OEE' here.&nbsp;&nbsp;

Forum Discussion

Using %GT columns in Measures

2 Replies

Related content

TMDL not finding column when used in measure, but column is available

Measure two columns

Measure Calculation Using Dynamic Column Names

Using measure as a filter

Using a Measure as a Legend in a Stacked Column Visual