Data Cache is not working

[Baskar]

Dear Friends, 

I have connected my Power BI with SSAS as Live connection.

I have six  line visuals in one page. 

Visual 1 : month wise / total customer count 

Visual 2 : Month wise / Avg sale { formula : Sales / Total cutomer count }

Here visual 2 not consider visual 1 cache. 

Visual 2 again running Total Customer Count 😞

any help. correct me if am went wrong 

[TomMartens]

Hey @Baskar ,

there is no cache that allows "inter" visual communication.

Each visual creates its own query, as the queries are not running in parallel, AS will maybe answer the 2nd query from it's cache.

Hopefully, this adds some additional insight.

Regards,

Tom

[Baskar]

Thanks @TomMartens 

Here which one execute first ?

If first query execute first then no issues, suppose second execute first then it will create an issue ?

[Baskar]

Sorry wrong window.

Regards

Baskar Vijayan

https://powerbi.baskarbiconsultant.com/

[TomMartens]

Hey @Baskar ,

what you are asking for is beyond this community, at least what I can provide during my spare time.

Regards,

Tom