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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Raj007
Helper III
Helper III

Drill through to details page from several cards

Hi, Thank you so much for your time,
I have this scenario where i show the cards and there are around 9 cards that display the measures of counts like count of ticket numbers that are open - 1 card for open, count of ticket numbers that are closed - 1 card for closed and so on... each card shows the numbers that are measures...

 

Say Card Open Tickets - is showing 250 , Card Closed Tickets - is showing 450, Card Emergency Tickets - 100
I do not want to build a separate drill through page for each measure..as it will be like 9 different pages for each status or for each measure... any suggestions on how i address this with one page which includes all the measures, all the columns that are required to present at the details level - any help is really appreciated

 

My Data model is very simple - 1 table with all data and i created 1 measures table just to include the measures

 

still researching but any help please...really appreciate your time... I just want to do 9 different pages

 

3 REPLIES 3
v-luwang-msft
Community Support
Community Support

Hi @Raj007 ,

Could you pls show  a sample ? Remember to remove confidential data.

 

Best Regards

Lucien

Hi, for some reason i do not see the option of attaching the files

Raj007
Helper III
Helper III

Hi, i forogot to mention something about the measures that i use on the cards

say for example; Open Tickets 500   - CALCULATE(distinctcount(TicketNumber),FILTER(TicketsTable,TicketstTable[State]="Open"))

 

i have the same approach for other measures on the cards - still researching

looks like when i use the measure in the details page drill through it will not pass the filter that i used in the CALCULATE function - any suggestions on the best possible solution for me

 

 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors