Visual taking long (using DAX from SQLBI site)

[Anonymous]

My visual takes a lot of time to load...

its a table with 2 columns:

- first column is this one 

https://www.sqlbi.com/articles/handling-customers-with-the-same-name-in-power-bi/

The other column is just a DISTINCTCOUNT:

CALCULATE(

    DISTINCTCOUNT(Fact[K_Parent_Customer])

    ,FILTER(Fact,Fact[NetRevenue] <> 0

    )

)

Is SQLBI's recommendation killing my visual?

[Anonymous · Accepted solution]

Hi @Anonymous ,

According to your statement, I think your issue should be caused that your calculated column from SQLBI will always create a rank in variable table and then repet adding space in your result by rank.

So each time you refresh your report , Power BI will calculate this column and your data size is too large, so it will take a lot of time.

I you try this in Power Query Editor, when you load data into Desktop, Power BI will remove the space in the end automaticlly.

So I suggest you to add the customer code into your visual to expand your visual and then turn off the text wrap function and set the column width of customer code column to 0.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , In case [NetRevenue] is measure

Countrows(filter(Values(Fact[K_Parent_Customer]), [NetRevenue] <> 0))

if [NetRevenue] is column

Countrows(Summarize(filter( Fact, Fact[NetRevenue] <> 0), Fact[K_Parent_Customer]))