Forum Discussion
Solved
Using Measures in Another Measure
Hi Guys, I need to calculate a measure from the selected values of the same Measure. I need to calculate what portion of sales people are internal of the total sales count i.e. Inter Sales Cou...
Highlight your measure in the field list and then use the Modelling tab in Power BI Desktop to change.
HI Phil_Seamark
I tried without the CALCULATE function too and that did not work. I get a value of 1 / 0 for aggregated columns.
E.g. SALES COUNT = 643
INTERNAL COUNT = 287
%Internal = 0
Can you set the decimal point to show multiple places
hi Phil_Seamark I cant see an option to set data types or decimal places for measures. How do I do it?
Highlight your measure in the field list and then use the Modelling tab in Power BI Desktop to change.
Thanks Phil_Seamark That seems to give me some data. Thanks. I am looking into the calculation.