Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
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
User | Count |
---|---|
98 | |
90 | |
82 | |
70 | |
67 |
User | Count |
---|---|
115 | |
104 | |
101 | |
72 | |
64 |