Dynamically Calculate the Frequency of selection

[Anonymous]

Hi Experts

Have slight trouble in trying to work out the frequency based on Date column from the atatched PBIX file. what i want to be able to do is if i have the following filter. 

Material_ID

Country_Orgin_NM

Manufacturing-Site

I want to be able to work out dynmically the frequency of the selection based on the Fical_Month_Start_DT column

so if i select just

1. Material ID from a filter..ID 72200561S i know we have 85

2. if i select Material_ID as above and then from filter USA we have 61

i want to be able to do this using a measure.

https://www.dropbox.com/s/hv5fahxl9juv9tb/Test.pbix?dl=0

[TomMartens · Accepted solution]

Hey @Anonymous ,

unfortunately I do not understand how you define "frequency" and how this relates to the date column.

But maybe it's as easy as this and you can define this measure:

Measure = COUNTROWS('PMSData')

or a little more complicated like this:

Measure = 
CALCULATE(
    DISTINCTCOUNT('PMSData'[FISCAL_MON_START_DT])
)

Hopefully this provides you with some ideas, if not, please what explain how the frequency has to be calculated.

Regards,

Tom

[Anonymous]

Hi Tom

Let me check and I'll come back to you.