Forum Discussion

Anonymous

Not applicable

8 years ago

Power BI Direct Query Measure Issue with 1M rows...

Currently I have a measure in Power BI supported by a direct query model. The formula for the measure is a simple count of records on a table filtered by another measure. Expression: Filtered ...

Anonymous

Not applicable

8 years ago

Hi Anonymous,

I find your have invoked other measure as the condition for filter, I'm not so sure combine use multiple measures with caused the issue.(if other measure has some operation will loop all table with complex operations)

Regards,

Xiaoxin Sheng

Anonymous

Not applicable

8 years ago

Hi Anonymous,

The other measure is also very simple:

Measure X = CALCULATE(DISTINCTCOUNT('Table1'[ID]); 'Dim1'[Atribute1] = "FilteredValue")

Anonymous
Not applicable
8 years ago
Hi Anonymous,

I found your measure calculate through multiple tables, I think the issue may related to loop calculate, count of the calculate exceed the 1M.

For example:
Table1, 10k + rows, dim table, 100k+, loop calculation count 10K *100K=1M

Regards,

Xiaoxin Sheng
- Anonymous
  Not applicable
  8 years ago
  And this is something normal and acceptable using DQ?
  This is something that should be able to work properly on the product since I am not returning more than 1M rows but yes calculating using joined tables that exceed 1M rows... This scenario is very common, no one is having this kind of issue?
  
  Thank you
  - Anonymous
    Not applicable
    8 years ago
    Hi Anonymous,
    
    >>This is something that should be able to work properly on the product since I am not returning more than 1M rows but yes calculating using joined tables that exceed 1M rows... This scenario is very common, no one is having this kind of issue?
    
    Actually, I still not sure which place will cause your issue.(I can't reproduce this)
    
    I'd like to suggest you contact to power bi team to know the detailed information about the this issue.
    
    Regards,
    
    Xiaoxin Sheng

Related content