Monthly Consumption Percentage

[paggierni]

Hello people,

I have a the next tables:

1. Activities, containing duration of the activities done:

Ticket ID                 StartDate                         EndDate                        Duration

1                            01/01/2020 11:00:00       01/01/2020 12:00:00           1

2                            01/02/2020  12:00:00     01/02/2020  14:00:00            5

2. Companies table with the names of clients with the monthly hours they can consume

Company                                    Hours

AnAwesomeClient                          5

AnotherClient                                 8

3. A Calendar table with Year, Month Number, Month Name, Date, Week, WeekName, etc.

4. A table with the tickets and other information.

Acts are related to the companies with the company with table number 4.

What i need to do is show in a visual clients that are under certain threshold of consumption percentage. The threshold needs to be variable. What if parameter?

Lets suppose I want to check this metric for January 2020, with clients under 50% of usage; Ticket 1 correspnds to AnAwesomeClient and Ticket 2 corresponds to AnotherCLient, the visual would only show the usage pecentage of AnotherClient.

Any help would be apperciated.

Thanks!

PS: Sorry for my bad english.

[v-easonf-msft]

Hi , @paggierni 

I'm confused about this word"A table with the tickets and other information.Acts are related to the companies with the company with table number 4." Can you explain it more and show  me the relationship view between tables ? 

Could you please share me more sample data and desired output screenshots for further analysis? You can also upload sample pbix to OneDrive and post the link here. Do mask sensitive data before uploading.

Best Regards,
Community Support Team _ Eason

[paggierni]

Hi @v-easonf-msft 

Thank you for your quick response.

You can download the pbix here 

The idea is to show which clients in the "Clientes Por Horas" table have consumed less hours than a threshold. This threshold must be expressed as percentage of "Horas Mensuales Contratadas".

Let me know if you need any further explanation.