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
RandimUser
New Member

How do I show records that were counted by Measure

I have a table of requests

 

Sample Table Data

Request IDRequest NameStatusRequest Approval DateStart DateEnd DateRelease Date
21082516390968Ref ID Change For Sales Compensation PlansCancelled9/10/20219/10/20219/10/2021null
21071208572930Collect EE Vaccination Status In Washington StateCancelled7/23/20217/30/20219/9/2021null
21070911353602Streamline International Transfers Wd ProcessCancelled7/21/20217/21/20219/8/2021null
21061713094926Awaiting Acceptance & Survey Notification AlignmentCancelled6/25/20216/25/20217/29/2021null
21051313364235Inclusion Training Announcement WidgetCancelled5/21/202110/1/202110/8/202111/30/2021

 

I have a measure that counts how many are cancelled and returns a total of records that meet the criteria

 

_Cancelled Requests =
CALCULATE(
COUNT('WD Project Link'[Request ID]),
'WD Project Link'[Status] = "Cancelled",
USERELATIONSHIP('WD Project Link'[End Date], 'Date'[Date])
)
 
How do I create a visual that shows the records that were counted?
 
Thank you
1 ACCEPTED SOLUTION
VahidDM
Super User
Super User

Hi @RandimUser 

 

If I understood correctly, you want to have a chart that shows only Cancelled and included in the _Cancelled Requests measure.

You can use the desired visual, then add that measure to the filter section and filter to not show the blank.

 

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

Appreciate your Kudos!!

 

View solution in original post

2 REPLIES 2
RandimUser
New Member

Thank you.

VahidDM
Super User
Super User

Hi @RandimUser 

 

If I understood correctly, you want to have a chart that shows only Cancelled and included in the _Cancelled Requests measure.

You can use the desired visual, then add that measure to the filter section and filter to not show the blank.

 

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

Appreciate your Kudos!!

 

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.