Creating a measure that highlights which group of values and hits a target, based on time

[Anonymous]

Hello all, hope you guys are fine.

In a nutshell, I have to create a measure that sums the values from a calculated column (based on a group, defined in other column of the table), and compare if it reached a target. All in between a certain interval of time, which will be filtered by the user.

To be more specific, let me provide a sample of what I am talking about: 

Think of it as: I have a Facts Table (image bellow), which records all goals a football player has made in a specific game. The first column is de code of the player, the third is the date of the game, and the last one is how many goals he/she scored.   

Also, I have a Dimensions table, with all the players in my database (image bellow):

The target is: For each player in my dimensions table, they need to have at least ONE goal registered in the facts table per week (or 4  or more goals total in a month, and so on).

Then, I want to use this measure to compare: from all the players in my dimensions table, what is the percentage of them that hit the target for each week/month/year?     

Hope you guys can understand and help me with this problem.

Regards,

[v-eqin-msft]

Hi @Anonymous ,

Could you please explain to me how to get the ONE or 4 or more goal registeredin your target ?

The target is: For each player in my dimensions table, they need to have at least ONE goal registered in the facts table per week (or 4  or more goals total in a month, and so on).

By counting the number of the calculated column- [Total de ...] ?

Could you please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data?

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