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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Sonnet
Helper I
Helper I

Two measures used in a table for drillthrough page

Hi everybody,

 

I have a summary page report and a drillthrough page report. On the summary page I have two visuals: One bar char and one line chart. On the drillthroug page there is a table visual.

On Y axis of the Bar chart I have a measure of Open records and on X axis the Calendar[Date].

On Y axis of the line chart I have a measure of Overdue records and on X axis the Calendar[Date].

 The measures are as follows:

Total Open Records = CALCULATE(COUNTx(FILTER('Fact','Fact''[Date Opened]<= max('Calendar'[Date]) && (ISBLANK('Fact''[Date Closed]) || 'Fact''[Date Closed]> max('Calendar'[Date]))),[Title]),CROSSFILTER('Calendar'[Date],'Fact''[Date Opened],None))+0

 

 

Overdue = CALCULATE(COUNTX(FILTER('Fact'',

ISBLANK('Fact''[Date Closed])&&'Fact''[Expected Completion Date ]<MAX('Calendar'[Date])
||
'Fact''[Date Closed]>'Fact''[Expected Completion Date ]
&& MONTH('Fact''[Date Closed])=MONTH(MAX('Calendar'[Date])) && YEAR('Fact''[Date Closed])=YEAR(MAX('Calendar'[Date]))
||
'Fact''[Date Closed]>MAX('Calendar'[Date]) && MAX('Calendar'[Date])>'Fact''[Expected Completion Date ]),[Title]),
CROSSFILTER('Calendar'[Date],'Fact''[Date Opened],None))

My question is if it's possible to use both measures on the table visual so that I can drillthrough from the line chart or the bar chart and landing on the same drillthrough page. I have tried adding them to the table and to the drillthrough page, but the results are not always correct.
Is there a away to use the two measures together on the same tale visual on the drillthrough page to show correct results?
Thanks in advance.




3 REPLIES 3
lbendlin
Super User
Super User

Drillthroughs are based on filters (the drillthrough columns you specify), not on measures. Not really clear to me what you are trying to do.

Something like this: https://www.youtube.com/watch?v=8_sJkP1nvsM
but with two measures on the second table. If I add two measures on the drillthrough table visual, the results are not right, i.e. if the values from the bar chart is 10 for the first measure, filtering those values on the drillthrough page I'd get less or more rows, in my example 9 or 12.
I hope I have been clear.

 

Measures do not matter.  You can recreate them or replace them on the drillthrough target.  All drillthrough does is impose the filter context from the user choice on the drillthrough target page.  You can see that in the "Filters on this page"  section where the drillthrough filters are in italics.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.