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,
When selecet Fiscal Week filter, how to caculate corresponding Fiscal Month(FM) KPI ? (please see attached image)
I had correct DAX for PreviousFM KPI ( all numbers match with DB):
But I cant get "FM KPI" correct, tried the following ways, but all caculated results don't match with DB:
@Anonymous , Try like
FM KPI =
VAR currentmonth = MAXX(allselected(vw_Reporting),vw_Reporting[Month Slno])
VAR FM KPI= CALCULATE([SAT%], ALL(vw_ReportingData[Fiscal Week]),vw_Reporting[Month Slno]=currentmonth)
RETURN FM KPI
FM KPI= CALCULATE([SAT%], ALL(vw_Reporting[Fiscal Week]), FILTER(vw_Reporting, vw_Reporting[Month Slno]=currentmonth))
FM KPI =
VAR currentmonth = MAXX(allselected(vw_Reporting),vw_Reporting[Month Slno])
VAR FM KPI= CALCULATE([SAT%], ALL(vw_ReportingData[Fiscal Week]),vw_Reporting[Month Slno]=currentmonth)
RETURN FM KPI
FM KPI= CALCULATE([SAT%], ALL(vw_Reporting[Fiscal Week]), FILTER(vw_Reporting, vw_Reporting[Month Slno]=Max(vw_Reporting[Month Slno])))
Hi amitchandak
Thanks for your reply!
I tried your DAX, it didn't work out. Please see enclosed images:
Have a question for you. In your DAX, you created a Variable "VAR FM KPI", but in your caculation(FM KPI= CALCULATE([SAT%], ALL(vw_Reporting[Fiscal Week]), FILTER(vw_Reporting, vw_Reporting[Month Slno]=Max(vw_Reporting[Month Slno]))) you didn't use this the variable which you created. Why?
Thanks again for your reply.
Sorry, I typed wrong in "FM KPI" DAX, correct one should be:
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 |
---|---|
42 | |
23 | |
21 | |
15 | |
15 |
User | Count |
---|---|
45 | |
31 | |
30 | |
18 | |
17 |