Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
calebsg
Frequent Visitor

MTD without measures (Direct Query)

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.

1 ACCEPTED 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"

View solution in original post

4 REPLIES 4
elliotdixon
Responsive Resident
Responsive Resident

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"

elliotdixon
Responsive Resident
Responsive Resident

Thanks for the update @pqian - looking forward to it.

HarrisMalik
Continued Contributor
Continued Contributor

@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.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors