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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
619SK
Helper I
Helper I

Age Category (with Filter status) - How to show 0 if no value or count for same

I' using Table/matrix for calculating age category.

Issue - by using filter for status in data, Age category shows only where value is present. How to show value/count as 0 if no value is present.

Example - If "Age Category" - ">180 Days" not having count so in Report view its getting hide as no value, My task is to show 0 if no count for category

619SK_0-1703856381364.png

 

Example :- 

Available Age categories
0-15 Days
15-30 Days
60-90 Days
90-180 Days
>180 Days
1 REPLY 1
AlienSx
Super User
Super User

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors