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.
I have written this DAX query but it takes quite a long time to render, is there anyway I can refactor this to return the result on the card visual faster?
postVPP =
VAR currentMonth = DATE(YEAR(today()), month(today()), 1)
RETURN
COALESCE (
CALCULATE (
DIVIDE ( [sumOfVendor], [Total Partners], 0 ),
USERELATIONSHIP ( 'Channel Table'[partner_key], fact_transaction_monthly[transaction_monthly_partner_key] ),
fact_transaction_monthly[transaction_monthly_charge_created_date] >= currentMonth
),
0
Solved! Go to Solution.
Hi, @Anonymous
I don't think this part can be further optimized.
This code is clear, understandable and maintainable enough.
You may need to check your current data model and other referenced mesures.
Best Regards,
Community Support Team _ Easo
Hi, @Anonymous
I don't think this part can be further optimized.
This code is clear, understandable and maintainable enough.
You may need to check your current data model and other referenced mesures.
Best Regards,
Community Support Team _ Easo
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |