Sync Filters in Power BI from 2 different Views

[Anonymous]

Hi,

I was working on one report in which there was one KPI - (Conversion Rate KPI) which involved multiple complex calculations. I had created that calculation in Power BI itself but now becasue of performace issue we moved that calculation in database side. We created one different view in the databse for that KPI which has different aggregation level data than Base data and now the performace in much better.

But Users want all filters should be sync through the report. But as I am using different view for that KPI which is now created in databse, all filter fields should be from that view only. So I am not able to sync those fields as rest of the KPIs are using different (Detail level) view.

I found one option that creating a bridge table. but for that we have to create 10 different bridge table for each of the filter and that bridge table filter we can use through the report but again it will affect on performace.

Is there any way so that we will have good performace and we can sync the filters through the report even if we get information from 2 different views?

Thank you!

Regards,

Poonam

[parry2k]

@Anonymous  Unfortunately you cannot pass your slicer/filter information down to your views. Best way is to create DAX expression to get what you are looking for so that filter/slicer can be used.

Since you already did using DAX and you are saying performance is very bad, you really need to review your DAX and make sure it is optimized and performance is good otherwise I don't see there is a way you can achieve what you are looking for?

Did you tried DAX studio to understand why DAX calculations are slow and not performing as expected? Bad written DAX can have big hit on peformance.

I know my reply is not very helpful and hope it will give different perspective. I work on very large and complex calculations and with optimized DAX, it works great.

Thanks,

P

[Anonymous]

Hi @parry2k ,

Thank you so much for your reply!

I am using below Dax expression:

Value Created = VAR LstDate = (max(Filter_Table[Filter_Date])) Return

CALCULATE (

SUM ( V_OPPORTUNITIES_OIF[OIF+] ),FILTER(V_OPPORTUNITIES_OIF, V_OPPORTUNITIES_OIF[Forecast_Category] in {"Booked", "Secure", "RoP", "Upside", "Risk", "Lost", "Cancelled"}), FILTER(V_OPPORTUNITIES, V_OPPORTUNITIES[Created_Date]<=LstDate&&V_OPPORTUNITIES[Created_Date]>=LstDate-364), FILTER(V_OPPORTUNITIES_OIF,V_OPPORTUNITIES_OIF[PO_Plan_Numbers]>=YEAR(MAX(Filter_Table[Filter_Date]))-1&FORMAT(MONTH(MAX(Filter_Table[Filter_Date])),"00")))

I am creating one variable and passing user selected date value in that variable to achieve the result.

Is there any way that the result can be achieve in more efficient way?

Thank you!

Regards,

Poonam