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 All,
I have a measure:
Solved! Go to Solution.
Hi @HFoy,
I'd need to see the relationships in your model and the structure of your tables to come up with an accurate answer. You should show that. Assuming the most typical structure, you could create a measure like this:
Measure = AVERAGEX ( ADDCOLUMNS ( FILTER ( ALL ( 'Calendar'[Date] ), YEAR ( 'Calendar'[Date] ) = YEAR ( SELECTEDVALUE ( Table1[Date] ) ) && MONTH ( 'Calendar'[Date] ) = MONTH ( SELECTEDVALUE ( Table1[Date] ) ) ), "_Day", [fc_Delivery_Rate] ), [_Day] )
Please always show your sample data in text-tabular format in addition to (or instead of) screen captures. That allows people trying to help to readily copy the data and run a quick test, plus it increases the likelihood of your question being answered. Just use 'Copy table' in Power BI and paste it here. Or, ideally, share the pbix (beware of confidential data).
Hi @HFoy ,
Have you solved your problem?
If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please share your data sample which could reproduce your scenario and your desired output so that we could help further on it.
Best Regards,
Cherry
Hi @HFoy,
I'd need to see the relationships in your model and the structure of your tables to come up with an accurate answer. You should show that. Assuming the most typical structure, you could create a measure like this:
Measure = AVERAGEX ( ADDCOLUMNS ( FILTER ( ALL ( 'Calendar'[Date] ), YEAR ( 'Calendar'[Date] ) = YEAR ( SELECTEDVALUE ( Table1[Date] ) ) && MONTH ( 'Calendar'[Date] ) = MONTH ( SELECTEDVALUE ( Table1[Date] ) ) ), "_Day", [fc_Delivery_Rate] ), [_Day] )
Please always show your sample data in text-tabular format in addition to (or instead of) screen captures. That allows people trying to help to readily copy the data and run a quick test, plus it increases the likelihood of your question being answered. Just use 'Copy table' in Power BI and paste it here. Or, ideally, share the pbix (beware of confidential data).
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 |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |