I want to create index wiht DAX for following table. But I could not create a column because working in Direct Query. That why I need a different solution. The index that will be created with DAX must be ranked with Quanty and sales prices. Sales price and Quantity are directly proportional; when one of them increases other one also increases.