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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
DebbieE
Community Champion
Community Champion

Month to Date DAX not working properly on a drill through report

I have a DAX query 

 

LM MTD Calls Offered = CALCULATE([MTD Calls Offered],DATEADD('Dim Date'[Date].[Date],-1,MONTH))
 
And I want to use it in a drill through report. 
You drill through on Month and Year to the drill through report. Annoyingly I get this
MTD DAX Issue 1.JPG
I added a card and its filtered to April which is blank (See the second column is blank)
I added it to a report without the drill through and it looks like this
MTD DAX Issue 2.JPG
Which is correct and If I add a card on here and add a slicer and go for April its fine.
 
I dont know what to do with this issue because the Drill through is on a data item in the date dimension 'Year Month'
 
And it means I cant see last Months figures in my card. Any help would be appreciated
 
To be clear, I want the Drill through report to show the figure for LM MTD Calls Offered
Report A the drill through report shows blank 
Report B is the report with no drill through or filters and you can see the number for  LM MTD Calls Offered
 
3 REPLIES 3
v-xicai
Community Support
Community Support

Hi @DebbieE ,

 

>>I added a card and its filtered to April which is blank (See the second column is blank)

 

>>Which is correct and If I add a card on here and add a slicer and go for April its fine.

 

From your description, I am not sure what desired result would you want, could you please share your sample data or desired output screenshots for further analysis? You can also upload sample pbix to OneDrive and post the link here. Do mask sensitive data before uploading.

 

Best Regards,

Amy

DebbieE
Community Champion
Community Champion

LM MTD Calls Offered is blank on the card in the drill through report 

I want it to have the correct number in from image 2 which is in the report with no drill through

Hi,

 

When you hover on one data point, the drillthrough page will return data about the data point. In your scenario, you may hover on the "14288" then click drillthrough. If you need to see all the data, you can choose the "Show data" option via click the ellipse in right upper corner of visual.

 

You can learn more about drillthrough:https://docs.microsoft.com/en-us/power-bi/desktop-drillthrough.

 

Best Regards,

Amy

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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