The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Can you help me break out of my mental box?
How would I have a MTD sales by sales rep without having a measures column?
When using the Import method I just add a measures column to the Sales Rep table getting the MTD total from the sales table.
Now with Direct Query and Enterprise Gateway I can't get my head around how to accomplish the same thing.
Solved! Go to Solution.
We are working on bringin measures to DirectQuery. Thank you for the patience 🙂
Meanwhile, if your MTD value can be calculated with relational algebra (demands a certain kind of schema to do this), then you can go into the queries view and add a new query to the same database, use the custom query field to write SQL for the intented value. When this query fills, it'll stay in DirectQuery mode and act like a "measure"
I agree with @HarrisMalik
I was planning on changing all my Power BI files over to be setup as Direct Query however without the ability to create measures there is no point. There is no point in using Power BI without the ability to setup measures.
Stick with the Import method and just wait for some more updates to the Enterprise Gateway to provide the data connection to more up to date information.
ED
We are working on bringin measures to DirectQuery. Thank you for the patience 🙂
Meanwhile, if your MTD value can be calculated with relational algebra (demands a certain kind of schema to do this), then you can go into the queries view and add a new query to the same database, use the custom query field to write SQL for the intented value. When this query fills, it'll stay in DirectQuery mode and act like a "measure"
@calebsg currently the calculated measures and calculated columns are not supported in directquery mode. As a solution if you have not very large dataset then use import data mode otherwise SSAS tabular model will be an answer.