cancel
Showing results for 
Search instead for 
Did you mean: 
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
Community Champion
Community Champion

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
Community Champion
Community Champion

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

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors