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,
I have facing performance issue with a measure in my power bi report where I have creating the below measure
Transaction Count =
COUNTROWS (
FILTER (
SUMMARIZE (
'Compiled Sales',
'Compiled Sales'[Store Code],
'Compiled Sales'[BillNo],
"Total", SUM ( 'Compiled Sales'[Sold Quantity] )
),
[Total] > 0
)
)
can this measure be created in another way currently this dax is taking 20 sec and my main fact table has 20 million records.
please let me know if any other information is requried.
Hi @Anonymous
Usually it should not be slow but in some occasions when creating a column inside SUMMARIZE. The thing is this is a simple sum calculation which leaves in doubts. However, you may try the following to avoid creating the column inside SUMMARIZE.
Transaction Count =
SUMX (
SUMMARIZE (
'Compiled Sales',
'Compiled Sales'[Store Code],
'Compiled Sales'[BillNo]
),
INT ( CALCULATE ( SUM ( 'Compiled Sales'[Sold Quantity] ) ) > 0 )
)
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 |
---|---|
46 | |
27 | |
21 | |
12 | |
8 |
User | Count |
---|---|
74 | |
52 | |
45 | |
15 | |
12 |