The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi @Greg_Deckler I have created a dax measure in power bi but it made the performance of the report very slow. I have two unrelated tables A and table B with dates and I have to get the sum of sales from table A where table A date(month,year) = table B (month,year). So I have created below dax measure
measure = calculate(sum(sales), filter(table A, month(table A) = month(table B)), filter(table A, year(table A) = year(tableB))
measure works fine. But the performance became very slow after getting this measure into the matrix. Please suggest
@Anonymous , ideally Create a common date table and filter both using the date table aulte
M1 = countrows(tableb)
M2 = Sum(TableA[Value])
M3 = sumx(filter( Values(Date[Date]) , not(Isblank([M1]))) , [M2])
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
67 | |
36 | |
21 | |
18 | |
15 |
User | Count |
---|---|
124 | |
39 | |
30 | |
24 | |
22 |