Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |