Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
1. Salaries are reported annually. However, they can change each month.
2. Bonuses are paid irregularly over different months.
I am trying to achieve:
Show in the table "Yearly Salary Vs Bonus" the correct results for Salary and Bonus while selecting a specific Month. OR if Selecting a YEAR from the year slicer, I would like the Salary of DEC of that year.
Please see link for the file.
https://basintamir-my.sharepoint.com/:u:/g/personal/tamir_tamirbasin_com/EbeTLvJsTwJGpYaV4f-6m44BbHN...
Thank you
Tamir
Hi @Anonymous,
You could create a measure below to meet your requirement.
Annual_Salary = IF ( ISFILTERED ( dimCalendar[MonthYear] ), MAX ( 'factsSallaries'[Annual Salary] ), CALCULATE ( SUM ( factsSallaries[Annual Salary] ), FILTER ( 'factsSallaries', 'factsSallaries'[Date] = ENDOFYEAR ( 'factsSallaries'[Date] ) ) ) )
The picture of result is below.
Picture_1 --no filter
Picture _2--by selecting the specific month
Additionally, you could refer to the PBIX file here.
Hope it can help you!
Best regards,
Cherry
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |