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.
Hello,
I have a report with live connection (ssas tabular) I'm facing an issue when i start the report as some calculation up to 1 minute to show up.
After troubleshooting , i find that i have a measure that is slower that another as bellow the definition of my measure :
The measure as below run in 7 s
CALCULATE (
[NbOrders],
FactSales[IsValid] = 0
)
Then i have another measure it takes 48 s
CALCULATE (
[NbOrders],
FactSales[IsValid] =1
)
Why the first measure is faster than another even if it's same with different filter
Thanks
As bellow the code of [NbOrders]
CALCULATE ( [Cnt], SUMMARIZE ( Sales, DimProduct[Product_id] ) ,SUMMARIZE ( Forecast, DimProduct[Product_id] ) )
The definition of Cnt as bellow :
Cnt := DISTINCTCOUNT ( Invoice[CustoID] )
Thanks
Hi @Anonymous ,
Can you try this code for [NbOrders]:
CALCULATE (
[Cnt],
FILTER ( Sales, [Product_id] IN VALUES ( Forecast[Product_id] ) )
)
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous
can you please share a screenshot of your data model?
The model is huge and the information is sensitive . Can i do it in private ?
@Anonymous
What is the code of [NbOrders]?
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 |
---|---|
47 | |
26 | |
22 | |
12 | |
8 |
User | Count |
---|---|
77 | |
50 | |
46 | |
16 | |
12 |