Forum Discussion
How can I combine formula in Data Model
If build relationships as
your PivotTable gives practically desired result.
The only it's better to use
perc late A:=DIVIDE( [Total late], [Total ontime], BLANK() )instead of
perc late:=[Total late]/[Total ontime]As third parameters in DIVIDE you may use whatever you want instead of BLANK().
Another point we have blank for hub areas, that means not all areas appears in Table1 and Table2 are in Table3. But that's better to adjust Table3.
Please check in attached file.
littlevillage Your file didn't include a DM with measures. Though it includes hidden sheets with numerous errors and circular references.
Nevertheless, see if the attached file does what you need.
Thank for your response
Actually, I want to get expect result directly from data ( column A:E)
I have created a pivot table from power pivot, but it returns the failed result
I have added an image and the link of the samplefile below that shows the expect result
Hope for your help
https://docs.google.com/spreadsheets/d/1Q5_5Uurc44ldWcopN4fE1hNA_9gdIweB/edit?usp=sharing&ouid=112310544159929632856&rtpof=true&sd=true
