Forum Discussion

Broly's avatar
Broly
Frequent Visitor
3 years ago

Salesforce data best practice

Hi, I'm a beginner in power Bi and needed some help.   I am importing three tables from Salesforce : Opportunities, Product and LineItemSchedule. An opportunity can have several products. A produc...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Broly , Try with this small change

 

new measure =
var _1 =CALCULATE(COUNT('Line Item Schedule'[Id]),'Line Item Schedule'[ScheduleDate]<TODAY())
return
SUMX(Opportunity, calculate(IF(_1>0,COUNT('Line Item Schedule'[Id]),0)) )

 

 

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.