DAX studio explain

Hi Analitika ，

Due to the above query in your post will return multiple rows data, it should be as a table. So please create a calculated table instead of creating a measure with the below formula:

tab =
VAR __DS0FilterTable =
    FILTER (
        KEEPFILTERS ( VALUES ( 'tbl_Companies'[Company_Name] ) ),
        NOT ( ISBLANK ( 'tbl_Companies'[Company_Name] ) )
    )
VAR __DS0Core =
    SUMMARIZECOLUMNS (
        ROLLUPADDISSUBTOTAL (
            ROLLUPGROUP (
                'tbl_comp_info'[Company_Name],
                'tbl_comp_info'[Detailed financials],
                'tbl_comp_info'[Name]
            ),
            "IsGrandTotalRowTotal"
        ),
        __DS0FilterTable,
        "MedianLQ_Revenue_growth", CALCULATE ( MEDIAN ( 'tbl_comp_ratios_others'[LQ Revenue growth] ) ),
        "SumTTM_Net_profit", CALCULATE ( SUM ( 'tbl_comp_ratios_others'[TTM Net profit] ) ),
        "MedianLQ_Net_profit_growth", CALCULATE ( MEDIAN ( 'tbl_comp_ratios_others'[LQ Net profit growth] ) ),
        "SumMarket_Cap", CALCULATE ( SUM ( 'tbl_comp_ratios_others'[Market_Cap] ) ),
        "SumEV", CALCULATE ( SUM ( '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] ) ),
        "SumWorking_Capital", CALCULATE ( SUM ( '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", '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],
        "SumTTM_FCF", CALCULATE ( SUM ( 'tbl_comp_ratios_others'[TTM FCF] ) ),
        "SumTTM_OP_CF", CALCULATE ( SUM ( 'tbl_comp_ratios_others'[TTM OP_CF] ) ),
        "SumTTM_FFO", CALCULATE ( SUM ( 'tbl_comp_ratios_others'[TTM FFO] ) ),
        "Exchange_list", 'tbl_comp_info'[Exchange list],
        "MinAttribute", CALCULATE ( MIN ( 'tbl_comp_ratios_others'[Attribute] ) ),
        "SumLQ_Revenue_growth", IGNORE ( CALCULATE ( SUM ( 'tbl_comp_ratios_others'[LQ Revenue growth] ) ) ),
        "SumLQ_Net_profit_growth", IGNORE ( CALCULATE ( SUM ( 'tbl_comp_ratios_others'[LQ Net profit growth] ) ) ),
        "SumEV_EBITDA", IGNORE ( CALCULATE ( SUM ( 'tbl_comp_ratios_others'[EV/EBITDA] ) ) ),
        "SumEV_FCF", IGNORE ( CALCULATE ( SUM ( 'tbl_comp_ratios_others'[EV/FCF] ) ) ),
        "SumP_FCF", IGNORE ( CALCULATE ( SUM ( 'tbl_comp_ratios_others'[P/FCF] ) ) ),
        "SumP_E", IGNORE ( CALCULATE ( SUM ( 'tbl_comp_ratios_others'[P/E] ) ) ),
        "SumP_S", IGNORE ( CALCULATE ( SUM ( 'tbl_comp_ratios_others'[P/S] ) ) ),
        "SumP_BV", IGNORE ( CALCULATE ( SUM ( 'tbl_comp_ratios_others'[P/BV] ) ) ),
        "SumDividend_yield", IGNORE ( CALCULATE ( SUM ( 'tbl_comp_ratios_others'[Dividend yield] ) ) ),
        "SumNET_DEBT", IGNORE ( CALCULATE ( SUM ( 'tbl_comp_ratios_others'[NET DEBT] ) ) )
    )
RETURN
    __DS0Core

And for the meaning of below formula, you can refer the content in this link to understand it.

"SumLQ_Revenue_growth", IGNORE(CALCULATE(SUM('tbl_comp_ratios_others'[LQ Revenue growth]))),

Best Regards