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
EricHulshof
Solution Sage
Solution Sage

%GT per month

Hello,

 

I made a dashboard where i have a KPI thats uses the %GT Count of ID. also adding a goal. Works like a charm and gives great insights.

 

I also have a filter per month. So when i select January i can see they made 92.40% and thats is above 90% wich is good, green. 

February they did 87% and it turns red, because its lower than 90%. 

 

Now i'd like to remove the month filter and show the % in a linegraph. However if i use %GT count of ID in a linechart i get about 8,50% each month. Because it then calculates howmuch January did for the GT instead of the GT of january. 

 

I hope my question is clear this way, if not feel free to ask for clarification.

 

Thanks.


Quality over Quantity


Did I answer your question? Mark my post as a solution!


1 ACCEPTED SOLUTION

Hi @EricHulshof ,

Maybe you could try this:

% Count of Madeit number =
DIVIDE (
    CALCULATE ( COUNTROWS ( 'Table' ), 'Table'[Madeit] = "TRUE" ),
    COUNTROWS ( 'Table' )
)

 

Best Regards,
Icey

 

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

View solution in original post

3 REPLIES 3
Icey
Community Support
Community Support

Hi @EricHulshof ,

Please give me some data sample and screenshots.

 

Best Regards,

Icey

So lets see.

 

i have incidents; shaped something like this:

 

IDDateReportedDate ResolvedPriorityTargetDateMadeit
110-10-201910-10-2019211-10-2019TRUE
211-10-201915-10-2019212-10-2019FALSE
315-10-201916-10-2019216-10-2019TRUE
415-10-201915-10-2019216-10-2019TRUE
515-10-201917-10-2019216-10-2019FALSE
610-9-201910-9-2019211-9-2019TRUE
711-9-201915-9-2019212-9-2019FALSE
815-9-201916-9-2019216-9-2019TRUE
915-9-201915-9-2019216-9-2019TRUE
1015-9-201915-9-2019216-9-2019TRUE

 

As you can see the total KPI for this would be 70%. As 70% is on time (7/10 times true). 

When i filter on september the KPI would turn to 80% as i have 4/5 on time. for october it would turn to 60% (3/5)

 

Now i try to get these values in a line chart. (Sept 80% to oct 60%) so i can see in what months it went over the desired KPI %)

 

For screenshots: i currently have the KPI like this:

 

Screenshot_4.pngScreenshot_5.png

As you can see i can not just use %GT count again. Since it just splits the 82% between the months. 

 

I hope this clarifies the problem. Thankyou.


Quality over Quantity


Did I answer your question? Mark my post as a solution!


Hi @EricHulshof ,

Maybe you could try this:

% Count of Madeit number =
DIVIDE (
    CALCULATE ( COUNTROWS ( 'Table' ), 'Table'[Madeit] = "TRUE" ),
    COUNTROWS ( 'Table' )
)

 

Best Regards,
Icey

 

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

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.