cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DebbieE Established Member
Established Member

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
Community Support Team
Community Support Team

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

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 Established Member
Established Member

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

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

Community Support Team
Community Support Team

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

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
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 160 members 1,941 guests
Please welcome our newest community members: