Create table from measure

Analitika — Wed, 14 Jul 2021 07:21:40 GMT

I have a lot of measures, i need create visual table from each measure median

"LQ_Revenue_growth", [LQ Revenue growth]),
"TTM_Net_profit", [TTM Net profit]),
"LQ_Net_profit_growth", [LQ Net profit growth]),
"Market_Cap", [Market_Cap]),
"EV", [EV]),
"EV_EBITDA", [EV/EBITDA]),
"EV_FCF", [EV/FCF]),
"P_FCF", [P/FCF]),
"P_E", [P/E]),
"P_S", [P/S]),
"P_BV", [P/BV]),
"Dividend_yield", [Dividend yield]),
"Gross_margin", [Gross margin]),
"Operating_margin", [Operating margin]),
"EBITDA_margin", [EBITDA margin]),
"Net_margin", [Net margin]),
"ROE", [ROE]),
"ROA", [ROA]),
"ROCE", [ROCE]),
"ROIC", [ROIC]),
"Inventory_turnover", [Inventory turnover]),
"Acc_receivable_turnover", [Acc.receivable turnover]),
"Acc_payable_turnover", [Acc.payable turnover]),
"Cash_conversion_cycle", [Cash conversion cycle]),
"Working_Capital", [Working Capital]),
"Equity_ratio", [Equity ratio]),
"Liquidity_ratio", [Liquidity ratio]),
"Quick_ratio", [Quick ratio]),
"Liabilities_Equity", [Liabilities/Equity]),
"NET_DEBT", [NET DEBT]),
"Net_debt_EBITDA", [Net debt/EBITDA]),
"ICR", [ICR]),
"DSCR", [DSCR]),
"Market_Place", 'tbl_comp_info'[Market Place],
"Super_sector", 'tbl_comp_info'[Super sector],
"Industry_m", 'tbl_comp_info'[Industry_m],
"Last_reported_quarter", 'tbl_comp_info'[Last reported quarter],
"TTM_FCF", [TTM FCF]),
"TTM_OP_CF", [TTM OP_CF]),
"TTM_FFO", [TTM FFO]),
"Exchange_list", 'tbl_comp_info'[Exchange list]

thoose measures i added to matrix as values

now i need to create one row in same matrix without including in total

or better new visual table where i need to count median of all companies

So how to create table from measure?

As nor

ADDCOLUMNS nor Sumarize not work from measure

Measure =
ADDCOLUMNS(
'tbl_Companies',
"MedianLQ_Revenue_growth", CALCULATE(MEDIAN('tbl_comp_ratios_others'[LQ Revenue growth])),
"MedianTTM_Net_profit", CALCULATE(Median('tbl_comp_ratios_others'[TTM Net profit])),
"MedianLQ_Net_profit_growth", CALCULATE(MEDIAN('tbl_comp_ratios_others'[LQ Net profit growth])),
"MedianMarket_Cap", CALCULATE(Median('tbl_comp_ratios_others'[Market_Cap])),
"MedianEV", CALCULATE(Median('tbl_comp_ratios_others'[EV])),
"MedianEV_EBITDA", CALCULATE(MEDIAN('tbl_comp_ratios_others'[EV/EBITDA])),
"MedianEV_FCF", CALCULATE(MEDIAN('tbl_comp_ratios_others'[EV/FCF])),
"MedianP_FCF", CALCULATE(MEDIAN('tbl_comp_ratios_others'[P/FCF])),
"MedianP_E", CALCULATE(MEDIAN('tbl_comp_ratios_others'[P/E])),
"MedianP_S", CALCULATE(MEDIAN('tbl_comp_ratios_others'[P/S])),
"MedianP_BV", CALCULATE(MEDIAN('tbl_comp_ratios_others'[P/BV])),
"MedianDividend_yield", CALCULATE(MEDIAN('tbl_comp_ratios_others'[Dividend yield])),
"MedianGross_margin", CALCULATE(MEDIAN('tbl_comp_ratios_others'[Gross margin])),
"MedianOperating_margin", CALCULATE(MEDIAN('tbl_comp_ratios_others'[Operating margin])),
"MedianEBITDA_margin", CALCULATE(MEDIAN('tbl_comp_ratios_others'[EBITDA margin])),
"MedianNet_margin", CALCULATE(MEDIAN('tbl_comp_ratios_others'[Net margin])),
"MedianROE", CALCULATE(MEDIAN('tbl_comp_ratios_others'[ROE])),
"MedianROA", CALCULATE(MEDIAN('tbl_comp_ratios_others'[ROA])),
"MedianROCE", CALCULATE(MEDIAN('tbl_comp_ratios_others'[ROCE])),
"MedianROIC", CALCULATE(MEDIAN('tbl_comp_ratios_others'[ROIC])),
"MedianInventory_turnover", CALCULATE(MEDIAN('tbl_comp_ratios_others'[Inventory turnover])),
"MedianAcc_receivable_turnover", CALCULATE(MEDIAN('tbl_comp_ratios_others'[Acc.receivable turnover])),
"MedianAcc_payable_turnover", CALCULATE(MEDIAN('tbl_comp_ratios_others'[Acc.payable turnover])),
"MedianCash_conversion_cycle", CALCULATE(MEDIAN('tbl_comp_ratios_others'[Cash conversion cycle])),
"MedianWorking_Capital", CALCULATE(Median('tbl_comp_ratios_others'[Working Capital])),
"MedianEquity_ratio", CALCULATE(MEDIAN('tbl_comp_ratios_others'[Equity ratio])),
"MedianLiquidity_ratio", CALCULATE(MEDIAN('tbl_comp_ratios_others'[Liquidity ratio])),
"MedianQuick_ratio", CALCULATE(MEDIAN('tbl_comp_ratios_others'[Quick ratio])),
"MedianLiabilities_Equity", CALCULATE(MEDIAN('tbl_comp_ratios_others'[Liabilities/Equity])),
"MedianNET_DEBT", CALCULATE(MEDIAN('tbl_comp_ratios_others'[NET DEBT])),
"MedianNet_debt_EBITDA", CALCULATE(MEDIAN('tbl_comp_ratios_others'[Net debt/EBITDA])),
"MedianICR", CALCULATE(MEDIAN('tbl_comp_ratios_others'[ICR])),
"MedianDSCR", CALCULATE(MEDIAN('tbl_comp_ratios_others'[DSCR])),
"Market_Place", BLANK(),
"Super_sector", BLANK(),
"Industry_m", BLANK(),
"Last_reported_quarter", BLANK(),
"MedianTTM_FCF", CALCULATE(Median('tbl_comp_ratios_others'[TTM FCF])),
"MedianTTM_OP_CF", CALCULATE(Median('tbl_comp_ratios_others'[TTM OP_CF])),
"MedianTTM_FFO", CALCULATE(Median('tbl_comp_ratios_others'[TTM FFO])),
"Exchange_list", BLANK()
)

Re: Create table from measure

Anonymous — Fri, 16 Jul 2021 01:20:33 GMT

HI @Analitika,

Perhaps you can take a look at the following blog which mentions the measure formula and calculation groups:

Creating Calculation Groups in Power BI Desktop - SQLBI

Regards,

Xiaoxin Sheng

topic Re: Create table from measure in Developer

Create table from measure

Re: Create table from measure