Create a measure that takes into account the number of observations when i move the slicer

[Ania_Learn]

Hello,

I have something as this table below and i want to create a mesure (as a reliability index).

The price here is a declared information, not always certain.

The idea is : if the selected period (with a slicer) has for example 30 registrations than do : create this performance index depending the number of registrations (i will think about it later) . If there are less, for example only 2 regitrations than  we cannot give it the same performance or reliability index.

What i mean is we cannot consider that this price is reliable if there are few observations during the selected period. Than i want to rate it from 1 to 10. 

Let's say i select something from March to April (30 days) and we have 2 registrations per day of the declared Price : i will consider the information as Good i will give it maybe 8/10 on a CARD. If there are more than 4 observations per day i will definitely give it a 10/10. But, if with my slicer i select from 1st June to 10 June and there is only three observations, than my  confidence in the reliability of the price will be only 3/10 on that CARD (depending on my condition that i will define later).

My question how can i create a interactive formula that recognize the number of selected observation when i use the Dates slicer or any other slicer? 

	Price
01 March	7
03 March	8
09-March	9
09- March	7,5
15-March	8,6
....
30 April	6
08 June	8,5
....

Thank you all

[dax]

Hi @Ania_Learn , 

I am not clear about your requirement, if possible could you please inform me more detailed information(such as your expected output and your sample data )? Then I will help you more correctly.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

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

[Ania_Learn]

Hey @dax ,

Of course , thanks 

[Ania_Learn]

Hey @dax thank you,

Of course, 

Hope it helps 🙂

[Anonymous]

I tried to retrieve publicly avaiable information from ERCO ( Electricity and Reliability Counsel of Texsas). Power BI gives me the following message.

Any suggestion on how to solve this problem?